Hi
post your existing macro :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"Amber M" schrieb im Newsbeitrag
...
In my macro I have rows of data that are automatically scanned and
subtotaled
with a grand total below. Is there any way to make the Grand Totals
consistently show up on Row 25 regardless of how much data was subtotaled
(assuming the data didn't overflow into row 25)?

Thanks!