Determine Excel cell location

J

John

$What method do I use to place into variable ToSheetCell the "$A$1"
column/row designation of the cell identified by
ToSheetCell = Sheets(ToSheet).Range(ToTable)(2, 1).????

I appreciate your help, -John
 
L

Lars-Åke Aspelin

$What method do I use to place into variable ToSheetCell the "$A$1"
column/row designation of the cell identified by
ToSheetCell = Sheets(ToSheet).Range(ToTable)(2, 1).????

I appreciate your help, -John
Click to expand...


???? = Address

Hope this helps / Lars-Åke
 

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

Merging cells in a table 1
Placing value in every col of a named range row 1
Clearing the contents of a row 2
Inserting a new table row without copying formats 1
Clearing only cells w/ numbers 4
Copy cell backgound color to another cell 1
Problem: Excel drops significant digits in copy value function... 1
Array with many cells from a row but not in order or together 11

Top