How to get cell reference 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 ????? with to get A2 printed in its place ?

Please help !!

score 2 · Accepted Answer · answered Aug 01 '11 at 12:19

2

With cell.Address(false, false).

answered Aug 01 '11 at 12:19

GSerg

score 1 · Answer 2 · answered Aug 01 '11 at 12:21

1

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.

answered Aug 01 '11 at 12:21

Luc Morin

2 Answers2