| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting items from Autofilter drop down
Hi Greg
1) I copy the two formulas you have in row 3 to row 2 so we have a empty row above you data When you use Ctrl * you see that the correct range is selected 2) your workbook is shared and this is one of the things that not work if you share your workbook 3) you want to filter on a column with empty cells and a X (enter something in the empty cells also) -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Send me your test workbook private and I look at it -- Regards Ron de Bruin http://www.rondebruin.nl "GregR" wrote in message oups.com... Ron, tried both your suggestions, added new row 4 which is empty, got the error. Removed new row 4 and set range("A4:AC100") and it errored in the same location. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I see more than 1000 autofilter drop down items | Excel Discussion (Misc queries) | |||
| AutoFilter and unique items | Excel Discussion (Misc queries) | |||
| subtracting (extracting non-duplicate items)HELP!! | Excel Worksheet Functions | |||
| Printing slected items after using autofilter | Excel Discussion (Misc queries) | |||
| extracting unique items | Excel Programming | |||
Threaded Mode
