Attempting to Highlight Cells Based on String within Cell

Hello!

Basically what I'm trying to do is the following:

First, determine if I'm in the correct row of cells based on the String value of the cell.
i.e If the current cell's string value contains the string AB1 or AB2, go through the entire row.

Once that has been determined, I would like to highlight the cells either green (if the cell holds a value greater than 5) or blue (if the cell holds a value between 4 and 5).

The above if block is not giving me trouble, it's the initial procedure.

What is stopping me from completing this is the run-time [error '91']: "Object variable or With block variable not set".

I do have some programming experience, I'm just having trouble with the syntax of VBA. Any help would be greatly appreciated.

Please Login or Register  to view this content.

Hmmm, ok! Thank you for your prompt response, I thought declaring the variable (Dim currCell As Range) would do it.

I have currently set it to:

Set currCell = Range("E10: AI155")

But now I`m receiving a run-time error `1004`: Application-defined or object-defined error on the first if statement. Any suggestions?

Here are before and after workbooks as requested! Thank you again for your help.

https://www.dropbox.com/s/9jj980pme1...efore.xls?dl=0
https://www.dropbox.com/s/cdnckqa66q...After.xls?dl=0

EDIT: Sorry I have the colors reversed in the workbooks.