Excel Worksheet function - Address

  • Thread starter Thread starter Bill Reed via AccessMonster.com
  • Start date 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
 
The Range object has an Address property (probably why the worksheet
function isn't available: its redundant)
MySheet.Cells(1,33).Address
 
Back
Top