Howard formulated the question :
On Friday, February 22, 2013 8:22:10 AM UTC-8, GS wrote:
Oops! ..missing closing parenthesis...



If Not Intersect(Target, Range($B$8:$G$25)) Then Exit Sub



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion

Hmmmmm! The revised does the same thing.

Howard

Yes, but with 1/4 the required processing! Your If construct requires
VBA to do 4 processes (1 for each condition) whereas the Intersect
function does the same thing in a single process. That makes using
Intersect() 300% more efficient in this context.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion