Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
After autofilter my results are not visible..
HI guys, I run a macro which filters a column. (The headers occupy the first 2 rows, the data starts in row 3) Problem is after filtering excel goes to (or I told it to goto) cell A1, and then it looks like there is not data to display from Row 3 downards - but if you just go down twice with your cursor there is data - ie the filter has worked fine but its just not displaying by default. HOW DO YOU TELL EXCEL to like "refresh" the screen so that the results of the filtering are visible???(irrespecitve if the filtered data starts on row 50, or 1000) Appreciate your help...!!! Regards Darin *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
After autofilter my results are not visible..
Darin,
Try: Range("A3:A65536").SpecialCells(xlCellTypeVisible) .Cells(1).Select HTH, Bernie MS Excel MVP "Darin Kramer" wrote in message ... HI guys, I run a macro which filters a column. (The headers occupy the first 2 rows, the data starts in row 3) Problem is after filtering excel goes to (or I told it to goto) cell A1, and then it looks like there is not data to display from Row 3 downards - but if you just go down twice with your cursor there is data - ie the filter has worked fine but its just not displaying by default. HOW DO YOU TELL EXCEL to like "refresh" the screen so that the results of the filtering are visible???(irrespecitve if the filtered data starts on row 50, or 1000) Appreciate your help...!!! Regards Darin *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i choose only visible cells from a autofilter? | Excel Worksheet Functions | |||
how can i choose only visible cells from a autofilter? | Excel Worksheet Functions | |||
autofilter sort not visible | Excel Discussion (Misc queries) | |||
AutoFilter: Loop Thru Visible Rows? | Excel Programming | |||
AutoFilter - which rows are currently visible? | Excel Programming |