| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range of unique cells
Hi All,
If I make a unique list with advanced filter, how can I define the range consisting of the unique cell, e.g. if in Range("A8:A23") cells A8, A9, A11, A15, A16 remained visible after fitering then what is the statement to define a range consisting A8, A9, A11, A15, A16 cells? Range("A8:A23").AdvancedFilter Action:=xlFilterInPlace, Unique:=True set uniqcells = ??? -- Thanks! Stefi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to only show unique cells in range (e.g. B2:B20) | Excel Worksheet Functions | |||
| Sum of unique values within a range with blank cells | Excel Worksheet Functions | |||
| unique list from a range of cells | Excel Programming | |||
| Counting Unique Empty Cells of a Range | Excel Programming | |||
| defining unique range of cells for different sheets as the same n. | Excel Discussion (Misc queries) | |||
Threaded Mode
