Fill the cells that is blank

Can anyone help me on this as I'm very beginner to VBA:

I have

MaxRow=Maximum row of A8:A100 that have data
MyRange= (F8:G "MaxRow",I8:J "MaxRow", L8:M "MaxRow")

Now I want to check if any cell in MyRange is blank then I will fill it with value = 0

Thank you,

Try this:

Please Login or Register  to view this content.

Many many thanks, now that I am understand little bit more about VBA

My pleasure.