mosquitoEEK
New Member
- Joined
- Jan 29, 2012
- Messages
- 13
Hi all,
Any suggestions for how to copy and paste non-contiguous named ranges from one workbook to another via VBA? For purposes of this question, I'm working with three columns as named ranges - Product, Country, and Region. They are in columns A, C, and E.
The only code I am working from is the one I had when I did not have columns A, C, and E as named ranges, only as static cell references. Please let me know if I can provide any other information.
Thanks in advance!
Any suggestions for how to copy and paste non-contiguous named ranges from one workbook to another via VBA? For purposes of this question, I'm working with three columns as named ranges - Product, Country, and Region. They are in columns A, C, and E.
The only code I am working from is the one I had when I did not have columns A, C, and E as named ranges, only as static cell references. Please let me know if I can provide any other information.
Thanks in advance!