delete rows when any cells in column A is filled in RED color

[William Poh Ben]

Hi people,

I need your help for a VB code that can delete the rows with any cells
in column A being filled in RED color ?


Alternatively, it will be fine for me if you have the code that can
move the rows to the top when there are cells being filled in RED color
in column A .


Thanks in advance for help.

 

[Dave Peterson]

If the colors are from formatting (not conditional formatting), you can use a
userdefined function that returns that color in a helper cell/column.

Then you could sort and delete.

Chip Pearson has the code for returning the value of the color at:
http://www.cpearson.com/excel/colors.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm