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