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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Getting values from Excel worksheet 4
Excel Concatenate with line breaks but ignore blank cells 3
Excel Disallow movement of embedded PDF 2

Back
Top