On Jan 30, 12:04*pm, Dave Peterson wrote:
I'm confused about your reply.

Did you try copy|pasting my first response into the worksheet module with the
commandbutton on it?

And what happened when you tried that?

If you changed the suggested code, it's time to repost your new version.



rink wrote:

<<snipped
I have tried what you suggest and if I just add Range or use before
the statement I get either a global error message or if I use the . it
wants a "Then or "Go To"

--

Dave Peterson

Dave,

I used the code suggested by JLGWhiz and that worked.