View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default 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.