View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_140_] John[_140_] is offline
external usenet poster
 
Posts: 57
Default Filtering data hides row

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?