Perhaps you could put your totals at the TOP.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John" wrote in message
...
When I filter data in Excel 2007 my totals row (at the bottom of the data)
dissappears. I put the following statement in my Worksheet_Change and
Worksheet_SelectionChange event:

Range("TotalsRow").EntireRow.Hidden = False

On large files this slows down my spreadsheet considerably. Is there a
better way to unhide this row when I filter data?