I want to select a variable range of cells in an Excel worksheet. To cell is A1, bottom cell can be found by using SHIFT+CTRL+DOWN ARROW.
If I record this as a macro it records the absolute or actual cell identified when the macro is run, i.e. it can not be run as a general macro.
Is there a VB equivalent to SHIFT+CTRL+DOWN ARROW?
I'm using Office 2000