PDA

View Full Version : macro for selecting all rows with a specifice font colour in the cell and copy/paste



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

stanleydgrom
09-17-2010, 04:05 PM
buhay,

I assume that your raw data begins in Sheet1 in cell A2.

Detach/open workbook buhay - VE34084 - SDG10.xls and run macro CopyRed.


Have a great day,
Stan

buhay
09-17-2010, 04:45 PM
it works, thank you very much mate:)