Thread: go to cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choice[_2_] choice[_2_] is offline
external usenet poster
 
Posts: 84
Default go to cell

Cells(Columns.Count, 2).Select
Cells(Rows.Count, 2).Select
shouldnt that go to B2? it goes to B65536

basically what i want is i have a value in "J1" (example 23) and i want is
Cells(Columns.Count, 2).Select
Cells(Rows.Count, Range("tracking!J1".Value).Select

and that would go to B23

thanks in advance