Near the end of a macro I need to select a range of cells from the ActiveCell then back 4 columns, and up 7 rows.
So the macro has been chugging along, adding values, calculating cells, and creating a Summary section.
In this example it ends on cell G129 and I need to go back and add a border around the summary section which begins at cell C122.
The problem is, the range C122:G129 will change each month. Depending on the data set used to generate the other part of the report this range can be + or - 10 or more rows.
I'm googling but my google-foo is weak right now.
Help?
Bookmarks