I don't think I understand the question. What does conditional formatting
have to do with copying and pasting cells?

--

Vasant

"Todd Huttenstine" wrote in message
...
I have a workbook that contains sheet1 and sheet2. I have
a VBA code that copies data from sheet1 Range A1:A10 and
puts that data in the corresponding cells in Range A1:A10
of sheet2.

Instead of using conditional formatting, how would I do
this using VBA?

Thank you.

Todd Huttenstine