Thread: Intersect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Don1975@gmail.com is offline
external usenet poster
 
Posts: 1
Default Intersect

I run into a code "91" error when I perform this function


sub mymacro()

If application.intersect(Activecell, Range("A1:IV16")) then
msgbox("wrong area")
else
msgbox("better")
end if

end sub

I don't have anything declared, can anyone help?