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

[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?

 

[Guest]

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.

 

[Guest]

Post your code. We can give you some general answers but it would be better
if we could see your code...

 

[Guest]

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.