VBA - If Or Statement?

[Chris424]

Hello,

I want to create code that will check if a number of cells is empty and if they are to call a sub. If any of the cells are not empty then call another sub.

I have tried using the following

Please Login or Register  to view this content.

But no matter what I try to do, I cannot add other cells.
I hope that makes sence,
Is anyone able to help?

[royUK]

Try this way

Please Login or Register  to view this content.

[Chris424]

Thank you, How would I add other cells? Such as D18 and D19?

[royUK]

Try

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

To cjeck a single cell

Please Login or Register  to view this content.

[Chris424]

Thanks again RoyUk but unfortunatly none of them seem to work?

[royUK]

Attach the workbook

[Chris424]

Just to simplify it, I changed the Subs to MsgBoxes:

Please Login or Register  to view this content.

But if the box is empty or not it still gives the MsgBox "Empty"

[Chris424]

Thank you, :-)

Its when clicking on the "New" command Button

[royUK]

The problem is that you are using MergedCells, these are generally to avoided because of the problems they cause. In effect the range is one cell

Please Login or Register  to view this content.

[Chris424]

That works perfectly now for one cell thankyou.
Is there a way of adding more than one cell
If D21 or D19?

[royUK]

You are already checking D21, it's not clear what you are asking - check individual cells or a range?

You code could be improved by removing the Selects like

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

You would also be better to use the sheet names with the ranges

[royUK]

This will shorten the Clear code

Please Login or Register  to view this content.