View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JonWestcot[_2_] JonWestcot[_2_] is offline
external usenet poster
 
Posts: 16
Default Question on copying a range

Hi:

Thanks for the reply. I'm trying to do this, though, in one workbook
that is open and pulling the information from another workbook that is NOT
open.

I'll keep your sample in mind, though; never know when it will come in
handy.

Thanks again!

Jon

Does this help?

Workbooks("source").Sheets("Sheet1").Range("nrange ").copy

"source would be the workbook you are looking to get the info from,
nrange would be the name of your named range, this assumes the workbook
is open.