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