| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Named Range using VB
Hi Guys
I want to create a Named Range making use of a dynamic amount of rows in a sheet. The examples I have will only accept a predefined range. ' I can select the range I want to name ActiveSheet.Range("AD2", ActiveSheet.Range("AD2").End (xlDown)).Select ' I now want to take that selection and name the range ActiveWorkbook.Names.Add Name:="DropListLoc", RefersToR1C1:="=NewProject!R9C5" This will only name the "C5" cell Thanks a stack Adriaan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a named range gives an error only when the filename is lo | Excel Discussion (Misc queries) | |||
| Creating a named range? | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Threaded Mode
