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

Range("A1:B2").copy
Cells(wherever i want to place it).Activate
ActiveSheet.Paste

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:

sheet2.cells(1,1)=sheet3.cells(3,5)