Select the next 1000 rows down and copy to clipboard
In vba, how do I copy down the next 1000 cells down from the active cell, into the clipboard? When I use the recorder it uses absolute values and I need relative values. Is there a setting in vba to tell it to use relative values instead of absolute? or is this something I just need to remember?