Determine Excel cell location
 

$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

Determine Excel cell location
 

On Wed, 11 Feb 2009 10:39:01 -0800, John
wrote:

$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


???? = Address

Hope this helps / Lars-Åke