Instead of Range please.

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro from active workbook whose name keeps changing 20
Code not working 3
VBA set thick borders around non empty cells in range 0
Formatting and copy or copy and formatting ?? 2
Create validation list with Worksheet_change 1
copy range using 4
Name the range AFTER copied to new sheet 6
do until loop 2

Back
Top