Excel Worksheet function - Address

  • Thread starter Bill Reed via AccessMonster.com
  • Start date
B

Bill Reed via AccessMonster.com

How do I get the address of a cell in an excel worksheet when I know its
row and column #s? Excel has a worksheet function, ADDRESS, that works
perfectly if I put it in a cell in a worksheet:

=ADDRESS(1,33)

It returns "$AG$1". But it won't run in the immediate window in my Excel
VBE, and its not available in objxl.WorksheetFunction, the excel
application object, either.

Any suggestions?

Bill
 
G

George Nicholson

The Range object has an Address property (probably why the worksheet
function isn't available: its redundant)
MySheet.Cells(1,33).Address
 
Top