Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with named ranges
The below code works, but I need to be able to select the sheet first. Is it
possible to do this with selecting the sheet, which in my case is (Visible = False) Sheets("sheetname").Select With Workbooks(WorkbookMain).Sheets("sheetname") .Range("Data_EMCSoftware").Select .Range(Selection, Selection.End(xlDown)).Select Selection.name = "Data_EMCSoftwareList" .Range("Data_SoftwareExclude").Select .Range(Selection, Selection.End(xlDown)).Select Selection.name = "Data_SoftwareExludeList" .Range("Data_SoftwareInclude").Select .Range(Selection, Selection.End(xlDown)).Select Selection.name = "Data_SoftwareIncludeList" End With -- Trefor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Named Ranges | Excel Programming |