transfer values and formatting without using .copy?

[aron]

Hi all!
I hope I get the formatting riught this time.

In a proceedure I'm trying to copy some ranges including: text,cellcolor and borders to a number of different places.
What I've got from modifying the macro recorder was

Please Login or Register  to view this content.

This works but I don't even want to have to activate the window or make a bunch of selections. Preferably I would want to operate everything from outside and whenever I opened the sheet the things would be there. Just as if I copied values from sheet1 by writing:

Please Login or Register  to view this content.

[romperstomper]

You don't have to activate:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

[aron]

Thanks romperstomper!
Worked like a charm.