Move cursor to first blank cell

[Aland2929]

1. My cursor is at the top of a range of data. I need to move the cursor down "n" rows to the first blank cell.
2. At that position, I need to enter a formula from the cell immediately above to the top of the range but excluding the header label?
Thank You.

[venkat1926]

your cursor in A1.do you want to go donw nth row or n+1st row and then move right and find the first blank cell.

on assumption you want n+1st row etc then try this macro

If necessary change the entry in inputbox for n

Please Login or Register  to view this content.

[Aland2929]

your cursor in A1.do you want to go donw nth row or n+1st row and then move right and find the first blank cell.

on assumption you want n+1st row etc then try this macro

If necessary change the entry in inputbox for n

Please Login or Register  to view this content.

I used the following code to move the cursor to the cell I need:
Selection.End(xlDown).Select
Selection.Offset(1, 2).Select
I there a better way to move down? In Excel I would press the End key once & the Down key twice. How do I do this in VBA?
Thank You.