Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|