I have 2 named ranges on 1 sheet and 1 named range on another..

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

Here is a short code that should do what you are asking:

Please Login or Register  to view this content.

- Moo

Originally Posted by Moo the Dog

Here is a short code that should do what you are asking:

Please Login or Register  to view this content.

- Moo

Thanks Moo! that's really helpful.. I'm still having issues with formatting however.. I'm really struggling to get the formatting of how things were in the source sheets for these ranges... at the moment when they arrive there are alot of issues is there some type of template I can use in sheet 3?

Also, I only wish to copy unhidden rows.. but I understand this is an issue with the ranges I have provided.