View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Object required - run time error 424.

And I have never gotten this error using code similar to Harald's.

--
Regards,
Tom Ogilvy


"y" wrote in message ...
I always selected the range with my mouse and the clicked OK.
I never closed the msgbox with the "X" at upright position.

Tom Ogilvy wrote:

If you click cancel, then you won't return a range and your set

statement
will produce that error.

Harald Staff gave you some sample code in a previous post.