View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick
 
Posts: n/a
Default How do I record a macro to move down and over to specific column

Cells(Activecell.Row +1,SpecificColumnNumber).Select

For example, to select column B, one row down from the current active cell:
Cells(Activecell.Row +1,2).Select


HTH,
Bernie
MS Excel MVP


"VMH" wrote in message
...
I want to record a macro that will move my cursor down 1 row and left to a
specified column. Not an absolute address