I have three named ranges:
"A" : named range on sheet 1
"Hello" : named range on sheet 1
"B" : named range on sheet 2
All I want is a simple macro that outputs the three ranges on a new sheet "sheet 3" contiguously underneath each other in the different order:
"A"
"B"
"Hello"
I should also note that I wish to preserve the formatting of these ranges and they are pasted into the new sheet.
Thanks in Advance!
M
Bookmarks