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.
|