buhay
09-17-2010, 11:17 AM
For example:
--------Column A-----Column B--------Column C-----Column D
Row1---- fonts
Row2
Row3 ---------------------------------fonts
Row4
the macro is supposed to select all rows with the fonts colour red (in this case row 1 and row 3) and copy paste it from sheet1 to sheet2.
Thanks in advance
--------Column A-----Column B--------Column C-----Column D
Row1---- fonts
Row2
Row3 ---------------------------------fonts
Row4
the macro is supposed to select all rows with the fonts colour red (in this case row 1 and row 3) and copy paste it from sheet1 to sheet2.
Thanks in advance