Trouble with if else then macro

[Ragga_NZ]

Hi all,

I am trying to code a macro that first checks cells B4,C4,D4 and E4 to check they have been filled in. If they haven't a msgbox should pop up prompting to fill in required cells. If the cells are filled in the various functions in the recorded macro should run.

Note, All relevant columns have data validation applied.

I have tried several methods. IsNull() with OR for the various cells, B4=""..., B4=0.. etc. but I can't seem to get it to work correctly.

In the code below, if the cells are empty the msgbox comes up however even when the cells are completed the msgbox comes up and the macro does not run the Else portion of the code.

Please Login or Register  to view this content.

[GC Excel]

Hello,

Here's a suggestion (with a bit of code clean up).
(warning : not tested !)

Please Login or Register  to view this content.

[jolivanes]

Or:

Please Login or Register  to view this content.