VBA Formatting Added T Incorrect Column

Hi, I wonder whether someone could help me please.

I've put together the following code which applies formatting to a given sheet.

Please Login or Register  to view this content.

The code works, except for this section:

Please Login or Register  to view this content.

What I'm trying to do is add the word "Fixed Resource" if any of the cells in column R, are emtpy.

This works, but the problem is that it also applies the same value to the cells in column Q and I'm not sure why.

I just wondered whether someone could possibly look at this please and let me know where I'm going wrong?

Many thanks and kind regards

Chris

probably a typo

Please Login or Register  to view this content.

Hi @nilem, thank you for replying to my post and for the solution.

I have to admit that it wasn't a typo but more stupidity on my part.

I had assumed that the second cell reference was used to determine which rows to check, i.e if column B was blank don't check column R.

A very useful learning experience!

All the best and kind regards

Chris

Hi @BS Singh thank you also for taking the time to reply to my post and for the solution. It is greatly appreciated.

All the best and kind regards

Chris