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?

--

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

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


.

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