View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PJFry PJFry is offline
external usenet poster
 
Posts: 143
Default 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.