Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing filtered cells
I have a database with many AutoFiltered columns. I'm writing a Sub that
will put an "X" in all visible cells in a specific column. To do so, I first need to erase or mark *all* cells in that record-keeping column so I then can mark only the visible cells. These methods fail: rngFull.ClearContents rngFull = "" rngCell.Copy rngFull Can anyone suggest a way to erase filtered cells, **without looping** and without unhiding the AutoFiltering? Thanks. Charley |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get SUMPRODUCT on filtered cells | Excel Worksheet Functions | |||
Numbering cells that have been filtered | Excel Worksheet Functions | |||
Calculating with filtered cells | Excel Discussion (Misc queries) | |||
filtered cells | Excel Discussion (Misc queries) | |||
Filtered Cells | Excel Programming |