Macro to copy a range that is constantly changing
Posted by Joe on May 22, 2001 9:27 AM
I have several columns and rows of formulas that I want to "copy" and "paste special" their values.
The problem is, the number of rows vary up and down but the macro I've written selects the same
number of rows each time. Basically it assigned a range and wants to use the same range each time.
I want the range to be variable based on the number of rows I'm targeting. In the old days, I would
simply anchor the cursor and use "end up" and "end right" to highlight the range I wanted to copy.