VBA If cell does not contain

Hi all,

I'm after a line of code which determines whether a cell does not contains the word "Saturday" or "Sunday".

The code I'd written below doesn't work:

Please Login or Register  to view this content.

An example of the format of the cells this macro will run through is as follows: Monday 27th, June 2022. These cells are in column E, hence the 5 in my code

Thanks!

Originally Posted by rorya

Depending on the answer to the above question, you'd need something like:

Please Login or Register  to view this content.

to check for weekdays in text.

Hi Rory, Yes it's formatted as just a string.
Unfortunately that doesn't work either. Rows with Saturday and Sunday are still being picked up.

I've attached an Excel with my code, using your solution which doesn't seem to work.

Originally Posted by rorya

Sorry, I misread your code. It should be:

Please Login or Register  to view this content.

Works a charm, thanks very much!