Object variable won't assign/set

[GeeWhiz7]

I've cut down the code to show the specific line I'm having an issue with.

Can someone help me understand why this variable won't set? Other variables (not shown in this snip) with slightly diffferent order in the Cells syntax get their values just fine.

For example, when I use the vLocCell to use the row address, this syntax works

vColor = Cells((vLocCell.Row), 6).Interior.Color

But in the snippet below, when I try to use it for the column the yellow won't set.
I'm lost as to why.

 

[Fluff]

Duplicate to: Non Volatile way (macro) to conditionally color cells by date and index

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.