On Wednesday, October 17, 2012 8:59:04 AM UTC-7, Bakar wrote:
Hi Everyone

can someone help please

let say I have in Sheet 1 in cells CW 24 =yes,CW 25 =yes,CW 26 =yes,CW

27 =yes,CW 28 =yes

If all thes cells are yes I want a macro to give me a message box

"Successfully completed!"



Thnxs for your valuable help

Bakar









--

Bakar

Hi Bakar,
Try this, meanwhile I will try to do it with a macro as you asked.

=IF(COUNTIF(CW24:CW28,"yes")=5,"S-C","")

Regards,
Howard