How do I record a macro to move down and over to specific column
 

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

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

How do I record a macro to move down and over to specific column
 

You can't...........in order to accomplish what you want you have to go into
the macro and edit it using the Offset (0,0) for Row and Column....yes, minus
numbers can be used to go to the left and upwards of the activecell...

If you need more h elp, send your code and requirement as to how many cells
you wish to move in which direction........someone will help.

Vaya con Dios,
Chuck, CABGx3



"VMH" wrote:

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