Hey Paul,

Thanks for the quick reply. I am trying to avoid the userform as then the user, as you noted, will have to select the range. If there is no way to call one sub for all command buttons (and then run code on the default name plus a wildcard, i.e. MyCOmmandButton*), then the option you suggested will work for me and I will use it. Thanks for the help again! Much appreciated!

Brock