How to use OR condition to add another target cell?

With Intersect(Target,cells(i,j) only, the code works fine but adding another statement after OR throws an error saying object or with block variable not set.

Objective: throw a prompt, for copy and paste, at row 86 and row 70 using worksheet event function.

Please Login or Register  to view this content.

Could use union:

Please Login or Register  to view this content.

Originally Posted by CheeseSandwich

Could use union:

Please Login or Register  to view this content.

Thanks. I like this elegant solution.

Originally Posted by sweep

Hi,

Try this..

Please Login or Register  to view this content.

Interesting I needed to declare nothing twice.