Conditional Cell color change
 

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

Conditional Cell color change
 

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

Conditional Cell color change
 

Nothing, I was just telling you that in case it was
important. I didnt know if it would be important info.


-----Original Message-----
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


.

Conditional Cell color change
 

Hi Todd,
Don't know what the first part of your question has to do
with Conditional Formatting.

For an example of how to use VBA instead of Conditional
Formatting see
http://www.mvps.org/dmcritchie/excel/event.htm#case
but it will depend on how cell value get changed.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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