VBA Code to check cell before running macro

[kolovel]

Hello guys
I need a vba code to check if some cells contain data (they must contain) before running a macro.

[shg]

Please Login or Register  to view this content.

[kolovel]

Ok but I need to check to different cells like B3 and B5... What should I write?

[karan]

This code would check in the used range of the active sheet:

Please Login or Register  to view this content.

Regards,
Karan

[tony h]

This will easily allow you to add multiple cells

Please Login or Register  to view this content.

[kolovel]

Thank you all for your advices. However the following worked for me:

If IsEmpty(Range("B3").Value) Or IsEmpty(Range("B4").Value) Then
.......
Else
........