Conditional Cell color change

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

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
 
I don't think I understand the question. What does conditional formatting
have to do with copying and pasting cells?
 
Nothing, I was just telling you that in case it was
important. I didnt know if it would be important info.
 
Back
Top