View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

When you say I want the cell reference to move to C98<< do you mean
you want the cell *pointer* to move? If so, then this line will move
the pointer to that cell:

Range("c" & Range("a1").Value).Select