Mesage box

[coltaalex]

Hi, could someone help me with VB, i have a column,
some cells in the column are red some are white after ruing a macro, some times no red at all - (conditional formatting ),
So i want a message box to appear if i have any red cells,
thank you

 

[SkipVought]

Hi,

Are you running VB 5 or VB 6 or are you in Excel VBA?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[coltaalex]

in in excel vba

 

[SkipVought]

Then, please repost your question in forum707, where it will be addressed.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}