how to run macro or msgbox when Worksheet does not exist/exist

**herukuncahyono** · 08-14-2013, 09:00 PM

Hi,
I want to run vba according to criteria value on column "B1: B5" sheet that exist or not the code is

Please Login or Register  to view this content.

if one of the cells in column "B1:B5"did not contain the name(except blank) of the sheet then msgbox appear if all exist run Macro1
thanks for help

**millz** · 08-14-2013, 09:27 PM

Edit: This should work now.

Please Login or Register  to view this content.

**herukuncahyono** · 08-14-2013, 09:48 PM

hi millz,
what if one of the value in column "B1:B5" ( e.g --> B5) is empty but still run macro1...?

**millz** · 08-14-2013, 10:05 PM

You mean you want to run macro1 even if there are only 4 worksheet names and one of the cells is blank?
If I understand you correctly, try this:

Please Login or Register  to view this content.

**herukuncahyono** · 08-14-2013, 10:54 PM

hi millz
correct...

thanks for helps

Re: how to run macro or msgbox when Worksheet does not exist/exist