| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA (or Excel) crashes if Count of Visible Rows in Autofilter Rang
Tom, I replied via Google but I do not yet see it via Agent
Tom Ogilvy wrote: do it manually - you will see that when only one cell is selected, then the special cells command works on the entiresheet. Possible work around: Set CurrRng = wks.Range(wks.Cells(DataStartRow, DataTopCol).Address, _ wks.Cells(wks.Cells(Rows.Count, "B").End(xlUp).Row, _ DataTopCol)) Set CurrRng = Intersect(CurrRng,CurrRng.SpecialCells(xlCellTypeV isible)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel copy only visible rows from autofilter | Excel Discussion (Misc queries) | |||
| Error, when autofilter does not return visible rows | Excel Programming | |||
| Autofilter - display column showing visible row count | Excel Discussion (Misc queries) | |||
| AutoFilter: Loop Thru Visible Rows? | Excel Programming | |||
| AutoFilter - which rows are currently visible? | Excel Programming | |||
Hybrid Mode
