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.

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.

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.