Run Time Error 91: Object Variable or With Block Variable not set

I have created a serial number list and when a cell is selected within a specified range the macro "X"s the cell and vice versa. But when I click on a cell outside the range specified it throws an Run Time Error 91: Object Variable or With Block Variable not set. Any Insight would be greatly appreciated.

Please Login or Register  to view this content.

hi, I think the problem is because Intersect returns a range so you need to check if it is Nothing rather than False.

change the first If statement from 'If Intersect(Target, rngToCheck) Then'

to 'If Not Intersect(Target, rngToCheck) Is Nothing Then'

see if that works for you.

Excelonthegrid,

Thanks that worked!