How do I use the Shift+Ctrl+down feature in a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to use a macro for new spreadsheets on a daily basis. I want to use
Shift+Ctrl+down arrow to copy down to the last record and each spreadsheet
has a different number of records. It works fine for the first spreadsheet
which had 571 rows but when I use it on another it only goes down to row 571
no matter how many rows are in the spreadsheet. Any ideas?
 
Assuming that the cell point is at the starting cell the code would be:

Range(Selection, Selection.End(xlDown)).Select

You could have recorded this little snippet too.
 
Post your code. We can give you some general answers but it would be better
if we could see your code...
 
You are also assuming there are no blank cells anywhere in that column before
the last entry. But you are correct that it would be the equivalent command.
 
Back
Top