How to select a range that will change in a macro
 

I have a report that I run and on month it can be 30 pages long and the next
month maybe 5 pages. I have a macroset-up so the report cuts out and
rearranges it in the way I like for the top part of the report. My problem
is there is usually an extra page that that I don't need that I would like to
get rid of, and then sum the columns at the bottom of my report. It works if
they are the same lenght of pages, but if I loose or dont cut off enough
information. Can anyone help?