Avoiding copy and paste, but need cell formatting

[jmpatrick]

I'm using this code to copy and paste without actually copying and pasting:

Worksheets("Calendar").Range("StartCell") = Worksheets("Template").Range("I5")

Works great but it only copies the cell value. Is it possible to also include the cell's formatting?

 

[Jaafar Tribak]

Any reason why you don't want to use copy paste ?

 

[jmpatrick]

Any reason why you don't want to use copy paste ?

It's VERY slow when logging to my machine remotely. If my workbook is on my work pc and I log using Gotomypc all the macros that have many copy and paste routines run extremely slow. When I use the VB above it's just as fast as if I'm sitting in the office.

 

[My Aswer Is This]

Show us your copy paste routines and maybe we have a solution for speeding them up.
You said you have many. Show us all of them.