Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to tab down 2 cells
Hello from Steved
My objective is no matter where I'm in the worksheet I want the macro to tab down 2 cells, below is my attempt. What do i need to do please. Sub Cursordown2() Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Select End Sub I thankyou. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to tab down 2 cells
Hi
Try this: ActiveCell.Offset(2,0).select Regards, Per On 29 Okt., 02:11, Steved wrote: Hello from Steved My objective is no matter where I'm in the worksheet I want the macro to tab down 2 cells, below is my attempt. What do i need to do please. Sub Cursordown2() Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Select End Sub I thankyou. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to tab down 2 cells
Hello from Steved
Thanyou very much "Per Jessen" wrote: Hi Try this: ActiveCell.Offset(2,0).select Regards, Per On 29 Okt., 02:11, Steved wrote: Hello from Steved My objective is no matter where I'm in the worksheet I want the macro to tab down 2 cells, below is my attempt. What do i need to do please. Sub Cursordown2() Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Select End Sub I thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for copying cells above empty cells | Excel Programming | |||
macro needed to copy blocks of cells across to list of cells down | Excel Programming | |||
Macro to select cells and then new selection from selected cells | Excel Programming | |||
macro to select cells containing specific text and delete all cells but these | Excel Programming | |||
a script/macro to copy a block of cells next to specified cells | Excel Programming |