Hi,
Here is my goal and I'm close but I can't seem to solve this error:
When a user changes a cell value in a column (let's say "I") that I specify, I want to highlight the active cell when the value is not equal to/within a named range (let's say "testrange2").
My named range ("testrange2") is in a different worksheet in the same workbook.
Here is my code thus far:
Here is the error I get:Please Login or Register to view this content.
Run-time error '1004':
Method 'Range' of object '_Worksheet' failed
..I don't understand what I'm doing wrong. Please help. : )
Bookmarks