View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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