Thread: Changing the active cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Changing the active cell
cells(activecell.row,1).Select

--
Regards,
Tom Ogilvy


"Patrick Simonds" wrote in message
...
What piece of code will cause the curser to go to Column A of the active
row? So if the cell is in R21 when the code is run I want the cell to move
to A22.



Reply With QuoteReply With Quote