| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding range name that includes a sheet name
Try... RefersTo:="=" & strRangeAddress
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "KarenH" wrote in message I am attempting to add ranges to a sheet based on another spreadsheet. I have named the range name strRangeName, and the corresponding range address as strRangeAddress. However, the range addresses will include worksheet names as well as ranges, for example: 'S-S-0'!$B$12:$D$63 The following statement in my code is failing: ActiveWorkbook.Sheets(strSheetName).Names.Add Name:=strRangeName, RefersTo:=strRangeAddress I'm fairly certain it's due to the range name, but I"m not sure of a way around it. Any ideas? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countifs criteria includes date range | Excel Worksheet Functions | |||
| Auto-filter includes too much range | Excel Discussion (Misc queries) | |||
| =max(range includes #N/As) | Excel Worksheet Functions | |||
| How do I sum a range which includes the "#N/A" VLOOKUP return valu | Excel Worksheet Functions | |||
| How to specify a Range which includes an integer variable | Excel Programming | |||
Hybrid Mode
