| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
| excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
Linear Mode
