Using Named Ranges in VB

[Rocky Bryant]

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

 

[Chip Pearson]

Rocky,

Enclose the name of the range in quotes. E.g.,

Range("dR").Select

 

[Ron de Bruin]

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?

 

[Ron de Bruin]

And see Chip his answer about the " "

 

[Jake Marx]

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")