Im using the following macro

Sub AddColumnt(
ActiveCell.Offset(0, 1).EntireColumn.Inser
Range("A1:A10").Copy ActiveCell.Offset(0, 1
End Su
It copies A1:A10 and inserts column and paste next to active cell

Cell A5 has a formula as well as conditional formatting using isformula UDF. The cell is colored yellow and if there is a formula it is white, so at the time of copy it is white. (Im' trying to see that user has over tpyed foormula). The copy picks up the CF but it doesnt pick up the cell color. Seems as though I can get the formula and the CF but not the cell color. What can I add to pick up that color as well as the CF

Many Thank
Steve