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
 
Top