I'm trying to figure out a way to copy a dynamic range from one workbook then paste into another
I know how to use a name range, just not sure about a dynamic range.
Copy dynamic range
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Copy dynamic range
Activate the source workbook.
Press Ctrl+G to activate the Go To dialog.
Type the name of the dynamic range into the Reference box (you can't select it from the dropdown list, but you can enter it yourself).
Press Enter or click OK.
You can now copy the range, and paste it into another workbook.
You won't copy the defined name this way, just the range. If desired, you can create a named dynamic range in the destination workbook.
If you want to copy the range together with the dynamically defined name, you can copy the entire sheet to another workbook.
Press Ctrl+G to activate the Go To dialog.
Type the name of the dynamic range into the Reference box (you can't select it from the dropdown list, but you can enter it yourself).
Press Enter or click OK.
You can now copy the range, and paste it into another workbook.
You won't copy the defined name this way, just the range. If desired, you can create a named dynamic range in the destination workbook.
If you want to copy the range together with the dynamically defined name, you can copy the entire sheet to another workbook.
Best wishes,
Hans
Hans