rng1.Copy
rng2.Pastespecial Paste:= xlPasteFormulas
rng2.Pastespecial Paste:= xlPasteFormats

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rene'" wrote in message
...
Hi
I would like to copy a range and paste it elswhere but only formulas ad
formats, without pasting the values that were int he copied range. How
would
I do this?
Thanks!
Rene'