Hi,
I have a range name with few cell containing conditional formation, when I
copy that range to an other workbook using code like this, the conditional
formatting is not copied.

Range("MYRANGE").Select
Selection.SpecialCells(xlCellTypeVisible).Copy

Application.Windows(temp2).Activate
Workbooks(temp2).Worksheets("MYSHEET").Range("A1") .Paste

Range("MYRANGE").Select
Selection.SpecialCells(xlCellTypeVisible).Copy

Application.Windows(temp2).Activate
Workbooks(temp2).Worksheets(MYSHEET).Range("A1").P asteSpecial
Paste:=xlPasteValues

I apreciate any help.
Thank you