Instead of Range please.
 

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.

Instead of Range please.
 

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.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Steved" wrote:

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.

Instead of Range please.
 

Hello PJFry

This is exactly what I require.

Thankyou

Steved

"PJFry" wrote:

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.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Steved" wrote:

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.