I am copying 500 rows of data. How would I recall these to use later in a procedure?
Could I use: RangeToUseLater = ??
Range(ActiveCell, ActiveCell.Offset(499, 0)).Copy
I need to run a few other thing before I get the range. Or do I need to re-org the sequence so I get it when I need it?