How to get cell reference from range object in Excel using VB.net?
I have :
Dim cell As Excel.Range = sheet.Range("A2")
Console.WriteLine("Cell references to = " + ????? )
What should I replace ????开发者_开发问答? with to get A2 printed in its place ?
Please help !!
With cell.Address(false, false)
.
You can use the Address property of the Range object, but you'll have to strip the '$' from it, as it returns the address in format "$A$2".
Hope this helps.
精彩评论