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