View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rocky Bryant Rocky Bryant is offline
external usenet poster
 
Posts: 1
Default 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