Setting up if cell is blank don't continue... and show a message.

This code works perfectly. I only have one question, I want to make it so that if there is nothing in cell Q23 that it will not put anything into NCMR Data, and say something... the code is below of what I have, and below it is what I think I need to do to a specific section to work, can someone review and make sure I am on the right path?

Please Login or Register  to view this content.

What I want to do I think:

Please Login or Register  to view this content.

Instead of:

Please Login or Register  to view this content.

I think what you want is:

Please Login or Register  to view this content.

Asking if "f Is Nothing" (or "Not f Is Nothing") only determines whether or not the range ('f') has been "set."

No go, Says Method or Data not found... and it highlights the row I just changed.

How about:

Please Login or Register  to view this content.

P.S. Before "Cell" should have been "Cells" (my mistake), but even so, Cells cannot take a "Q23" type reference whereas Range can.

Nope, still allow entering of data with nothing in it. Here is the script as of now.

Please Login or Register  to view this content.

Are you sure that wsInt.Range("Q23") is empty? Could there be an empty space character left over inside the cell which might not show? Or is there a formula inside that cell?

You might try something like:

Please Login or Register  to view this content.

Trim should takeout any spaces (it takes out leading and trailing spaces from a string).

Originally Posted by StevenM

Are you sure that wsInt.Range("Q23") is empty? Could there be an empty space character left over inside the cell which might not show? Or is there a formula inside that cell?

You might try something like:

Please Login or Register  to view this content.

Trim should takeout any spaces (it takes out leading and trailing spaces from a string).

I am positive, here is the page in question. Without the code. Just to show you what I am attempting to do.

I ran the following test a number of times on your worksheet.

Please Login or Register  to view this content.

And when I put a value in Q23 ("Sales Order"), and ran the above macro, it tested as not empty.
Then when I deleted a value in Q23, it tested as empty.

I then copied and pasted your code, and it ran as expected. When there was nothing in Q23, the message popped up, and when there was something in Q23 it bypassed the message.

I'm at a loss to understand your problem.

Originally Posted by StevenM

I ran the following test a number of times on your worksheet.

Please Login or Register  to view this content.

And when I put a value in Q23 ("Sales Order"), and ran the above macro, it tested as not empty.
Then when I deleted a value in Q23, it tested as empty.

I then copied and pasted your code, and it ran as expected. When there was nothing in Q23, the message popped up, and when there was something in Q23 it bypassed the message.

I'm at a loss to understand your problem.

Because if you look at the code you originally suggested and what you have down here it is different format wise. There is no Exit Sub, or other parts in it like your original post. I'll try out the code you just posted and get back to you on it.