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