Thanks Very much It worked out.

"Tom Ogilvy" wrote:

selection.Copy
With Worksheets("SheetOther").Range("A1")
.PasteSpecial xlValues
.PasteSpecial xlFormats
End With

--
Regards,
Tom Ogilvy


"VishalBade" wrote:

I have two excel sheets, One sheet is where i do all calculations, have
formulas defined and have conditional formatting defined. But when i copy to
the other excel i just dont need to copy formulas, except formulas I need to
copy values and special formats.

How do i do that. I have tried pastespecial - xlPasteValuesAndNumberFormats,
but it does not carry forward conditional formatting.

thanks in Advance