How to activate message box to continue the macro.

Hi Guys

I have found this macro to add null into blanks in my VBA but if there are no blanks the message box pops up to say so and clicking OK makes it go away but the remainder of my macro does not run. If i have a blank then it runs fine.

Here in the code:

Please Login or Register  to view this content.

Love to solve these small issues but i have labored for hours looking for the solution.

Mark

The resume next statement will just do that. and the next statement is the end of sub . Change the return back to the active section

Hi Thanks for this. Must be one of the stupidest questions I have ever asked.
Wow you are miles away. I am in London.
Mark

There are no stupid questions. All answer will enhance our knowledge and widen our grip on things.
You are welcome. Any time.

Hi RCM
The above is great but my need has changed. How could I write it to enter the value of the cell above if it is null.

Not sure if you will get this .

Mark

Using your clear explanation i go

Please Login or Register  to view this content.