I just figured out what I think happened. Yesterday I created a user form.
I deleted the click word and a macro on the user form was exactly the same as
in my project. At least that is what I think happened. On that form if you
click the buttons there is no code window only a blank on all the buttons.
Obviously corrupted. Ideleted the form. It still doesn't compile. It says
invalid procedure call. It stops on rng as RAnge, the second line.

thanks,

"stevebriz" wrote:

I added this code to a module and it compiled find.

what line does the compile error come up on? and does it give a
message?