| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to replace advanced auto filter
Is there code that will replace using advanced autofilter in a shared
workbook? currently when i turn my workbook on to shared, the advanced filters embedded do not work. Currently I am using: Sheets("East Master Repository").Select Rows("1:1").Select Cells.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Sheets( _ "Criteria for market groupings").Range("N2:N7"), Unique:=False Cells.Select Selection.Copy Workbooks.Add ActiveSheet.Paste Where my filter criteria is in cells N2 thru N7. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to replace Advanced Filter | Excel Discussion (Misc queries) | |||
| Find part of a word in Advanced Filter Code | Excel Programming | |||
| Problems implementing advanced filter code... | Excel Programming | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| Auto filter Code | Excel Programming | |||
Threaded Mode
