| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set range to autofiltered visible cells?
I am apply autofilter with criteria "aaa" on column 18 which gives me
4 rows visible. Then I am trying to assign filtered visible rows (except top header row) to a range but getting error of object required. I have tried different variations of below code. Set RNG = WSSR.Range("A1").AutoFilter(Field:=18, Criteria1:=COLSHIP.Item(1)) RNG and WSSR are already defined. COLSHIP is collection of unique values. Applying autofilter on one of the value in COLSHIP which is in column 18. Pl help. Regards, Madiya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save autofiltered visible sheet to csv file? | Excel Discussion (Misc queries) | |||
| Sum only visible cells within a range. | Excel Programming | |||
| How to plot only visible autofiltered rows in a data list | Charts and Charting in Excel | |||
| Selecting Column of Visible AutoFiltered Cells. | Excel Programming | |||
| Error stepping through Autofiltered visible range | Excel Programming | |||
Threaded Mode
