How to get cell link from range object in Excel using VB.net?

Question

I have:

Dim cell As Excel.Range = sheet.Range("A2") Console.WriteLine("Cell references to = " + ????? ) 

What should I replace ????? to get A2 printed in its place?

Please, help!!

Answer 1

With cell.Address(false, false) .

Answer 2

You can use the Address property for the Range object, but you will have to remove the "$" from it, since it returns an address in the format of "$ A $ 2".

Hope this helps.