Put Autofilter in VBA long to run
 

In an EXCEL sheet witch contain many numbers and formulas, I put a
Autofilter on a column by coding in VBA. After I put a Criteria:="*E*"
in the Autofilter. My problem is when I try to change the Height of al
row of the filter's result, it tooks about 15 minutes to complete. Th
sheet has about 6000 row. Is anybodies knows why it took so lon
time....Thanks...


Columns(1).AutoFilter Field:=1, Criteria1:="*E*"

'This command tooks about 15 minutes.....
Range(Rows(intFirstInputRow), Rows(intLastInputRow)).RowHeight = 0.

--
Message posted from http://www.ExcelForum.com