Vba to change cell color if text has only 1 word (SAVE MY JOB PLS)

Hello,

I'm a excel newbie and been studying and learning for the past 2 months, so forgive me if what I ask happens to be stupid

I was trying to create a code that changes the color of a cell if the cell value contains only one word


For example: I have a column with names and surnames, and I want to highlight entries that do not contain a surname (that means it's a single word value) with a RGB color

I'm not a real coder, and all my success attempts in other situations was adapting/merging codes I find in the internet, but I can't find anything related to this. Anyway, my only attempt that didn't result error (but didn't do anything at all) was the following:

Please Login or Register  to view this content.

I came across somecodes that use the split function to result a single value as an error, then a ISERROR would recognize the cells marked as an error and change the color of it, so I tried to do something similar

If anyone could help me out I'd be extremely thankful!

Pedro.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

No need for 2 loops.

Please Login or Register  to view this content.

UBound determines the size of an array, if there is only one word in the cell then when you use Split with a space as a delimiter you will get an array of size 0, if there is more than 1 word in the cell then the size will be greater than 0.