blackie42
10-20-2016, 02:20 AM
Hi,
I need to blank some adjacent cells when selecting from a dropdown list.
Using the following but getting an error 'Run time error '91', Object variable or With block variable not set'
If Intersect(Target, Range("G:G")) = "Scrub" Then Target.Offset(, 3).Resize(, 1).ClearContents
So if I select Scrub in G2 then J2 contents are cleared but then it bugs out.
Any help appreciated
thanks
Jon
I need to blank some adjacent cells when selecting from a dropdown list.
Using the following but getting an error 'Run time error '91', Object variable or With block variable not set'
If Intersect(Target, Range("G:G")) = "Scrub" Then Target.Offset(, 3).Resize(, 1).ClearContents
So if I select Scrub in G2 then J2 contents are cleared but then it bugs out.
Any help appreciated
thanks
Jon