| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create named range in each sheet in workbook
I'm using this code to delineate the range I want filters applied to:
Range(Range("b3"), Range("b3").End(xlDown).End(xlToRight) _ .Offset(-1, 2)).Select Now I want a macro to go into every worksheet in the workbook, the number may vary, and create a named range called FilterRange with the worksheet's name. Than I can use that named range to apply filters to from buttons/macros. Can anyone help me here? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook | Excel Discussion (Misc queries) | |||
| How to create a dynamic named range? | Excel Discussion (Misc queries) | |||
| Create a Named Range in Excel with VBA | Excel Programming | |||
| List named range per sheet in workbook | Excel Programming | |||
| Create named range | Excel Programming | |||
Threaded Mode
