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.
|