| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem creating a named range
Code looks like this:
ActiveWorkbook.Names.Add Name:=varName, RefersTo:="Sheet!" & varStartCell Creates a name, which I cannot use, because it is surrounded by quotation " " symbols. Note about Varname: is created after stripping out spaces from user entered input; varStartCell is an absolute reference like $A$5 TY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a named range? | Excel Discussion (Misc queries) | |||
| Problem with creating a named range | Excel Programming | |||
| Creating a named range | Excel Programming | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Creating a Named Range using VB | Excel Programming | |||
Threaded Mode
