Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Named Ranges in VB
Hello,
In WkBk1 I have defined a dynamic range dR which points to cells in WkBk2. Code in Module1 in WkBk1 I want to Select dR. so I do the following. Range(dR).Select but this line seems to be giving me an error. Can you actually us a Named Range in VB code? And how would I accomplish this? thanks for you help, Rocky |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Named Ranges in VB
Rocky,
Enclose the name of the range in quotes. E.g., Range("dR").Select -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Rocky Bryant" wrote in message ... Hello, In WkBk1 I have defined a dynamic range dR which points to cells in WkBk2. Code in Module1 in WkBk1 I want to Select dR. so I do the following. Range(dR).Select but this line seems to be giving me an error. Can you actually us a Named Range in VB code? And how would I accomplish this? thanks for you help, Rocky |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Named Ranges in VB
Hi Rocky
You can't select a range in a other workbook this way. First you must make the workbook and the sheet active. You don't have to select the cells if you wnat to do wht you want maybe? What do you want to do? -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Rocky Bryant" wrote in message ... Hello, In WkBk1 I have defined a dynamic range dR which points to cells in WkBk2. Code in Module1 in WkBk1 I want to Select dR. so I do the following. Range(dR).Select but this line seems to be giving me an error. Can you actually us a Named Range in VB code? And how would I accomplish this? thanks for you help, Rocky |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Named Ranges in VB
And see Chip his answer about the " "
-- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Rocky You can't select a range in a other workbook this way. First you must make the workbook and the sheet active. You don't have to select the cells if you wnat to do wht you want maybe? What do you want to do? -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Rocky Bryant" wrote in message ... Hello, In WkBk1 I have defined a dynamic range dR which points to cells in WkBk2. Code in Module1 in WkBk1 I want to Select dR. so I do the following. Range(dR).Select but this line seems to be giving me an error. Can you actually us a Named Range in VB code? And how would I accomplish this? thanks for you help, Rocky |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Named Ranges in VB
Ron de Bruin wrote:
You can't select a range in a other workbook this way. First you must make the workbook and the sheet active. Or you can use Application.Goto to change the selection to a cell in another worksheet and/or workbook: Application.Goto Workbooks("other").Sheets(1).Range("C150") -- Regards, Jake Marx www.longhead.com "Rocky Bryant" wrote in message ... Hello, In WkBk1 I have defined a dynamic range dR which points to cells in WkBk2. Code in Module1 in WkBk1 I want to Select dR. so I do the following. Range(dR).Select but this line seems to be giving me an error. Can you actually us a Named Range in VB code? And how would I accomplish this? thanks for you help, Rocky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named ranges? | Excel Worksheet Functions | |||
named ranges | Excel Worksheet Functions | |||
named ranges | Charts and Charting in Excel | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges and VBA Add-ins | Excel Programming |