ok, thanks everyone for the replies. i have it now

--


Gary


"Gary Keramidas" <[email protected]> wrote in message
news:%[email protected]...
> when you use the .copy method, is there any way to only copy formulas? or
> do you have to use the paste method to achieve this?
>
> this copies formats, too
>
> Worksheets("Sheet1").Range("A1:D4").Copy _
> destination:=Worksheets("Sheet2").Range("E5")
>
>
> --
>
>
> Gary
>
>
>