Search for Singular Yellow Row

[trevor2524]

Hello,

Does anybody know a macro that will search Column A for Yellow Cells. If it finds a Yellow Cell it will then check to see if the row below it has any value.If there is not value in the cell right below it then it will Delete that entire row that the Yellow Cell is on and stop the program. If it finds a value it will then continue down the column looking for another Yellow cell. The reason for this macro is because I have another macro that is deleting duplicates and it sometimes leaves a Yellow Row at the bottom of my information.

[ranman256]

Please Login or Register  to view this content.

[trevor2524]

Thank You!