| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges: Can I do This? How?
shtSup1.Names.Add Name:="Sup1_BCAPA_Ratings", _
RefersTo:=Supplier!$C$6,Supplier!$C$16,Supplier!$C $23,Supplier!$C$36, _ Supplier!$C$56,Visible:=True I want to add named ranges in my workbook with VBA. However, the range that I have is discontiguous as noted above. I can enter it in the Insert/Name/Define and it works. How do I write the code so that it compiles in VBA? I keep getting an error. Supplier is the name of the worksheet. I am working in Excel 2003. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named ranges and pasting formulas with named references | Excel Programming | |||
| Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
| union of named ranges based only on the names of those ranges | Excel Programming | |||
| 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) | |||
Threaded Mode
