Excel Macro End if

[b50]

Hi I have the following part of a macro. What I need it to do is check if each cell in column U have the value a,b,c,d, or is blank. If it is one of those values (or is blank) then continue on to the rest of my macro. However, if it is not one of those values then create a message box saying which cell it is in, and end the macro.

I started writing a little below, but got confused at this point.


Thanks to anyone who can help.

Please Login or Register  to view this content.

[stanleydgromjr]

b50,

Try:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

Or, try:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

[rylo]

Hi

see how this goes

Please Login or Register  to view this content.

rylo

[shg]

Another way:

Please Login or Register  to view this content.

[b50]

Ok, I adjusted teh code a little, just so that it matches the names I need, but for some reason the error message keeps coming up. The names in the code exactly match what is in the spreadsheet, but it is still having problems.

Any idea what is going on?


Thanks for your help.

Please Login or Register  to view this content.

b50,

Try:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

Or, try:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

[Leith Ross]

Hello b50,

The code UCase converts all of the letters in a string to capitals. If you want to capitalize only the first letter of each word then you need to use the Proper function. I have added this function to the macro below.

Please Login or Register  to view this content.

[b50]

Works perfect thanks!!!

[shg]

b50, please don't quote whole posts -- it's just clutter.

Thanks.

[stanleydgromjr]

b50,

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.