Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Named Ranges in VBA
All,
Using Excel 2000, I'm unable to programmatically create a named range. I have a series of lookup tables which I export from a database to an Excel spreadsheet (all standard code/description-type lookup tables). I then want to create a named range for each lookup table's data. I've tried both the following methods and, while neither generates an error, they do not create the named range: 1. MyWorksheet.Names.Add Name:="NewRangeName", RefersToR1C1:="R1C1:R14:C2" 2. Range(Cells(1, 1), Cells(14, 2)).Name = "NewRangeName" Any ideas? Thanks, Mark D'Agosta |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem creating named ranges in a Macro! | Excel Discussion (Misc queries) | |||
Creating dynamic ranges which are named. | Excel Worksheet Functions | |||
Using named 3-D ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions |