Mike,

I don't see a way to call 'MySub' from Excel directly, without resorting to a small macro in the format that Stephen points out. I'll try to dig around to see if it is possible or not...

BTW, you can remove all those "Calls" from your code. Unless you *want* them there, there's really no point in having them....