Instead of Range please.

[Steved]

Hello from Steved

How do I tell this to drop down to the next cell meaning Range("A9").Select

Sub CtrlD()
Selection.FillDown
Range("A9").Select

End Sub

I Thankyou.

 

[PJFry]

Can you give an idea of what the code is supposed to do?

If you are looking to move down on row from the where ever your active cell
is, you can use this:
ActiveCell.Offset(1, 0).Select

Post back and let us know.

 

[Steved]

Hello PJFry

This is exactly what I require.

Thankyou

Steved