Sure, but in his original post he said he has about twenty different values and he's hoping not to have to make a Select statement with twenty different cases. It's possible to rig that in VBScript, using an Execute statement, but VBA doesn't have that statement. Is there some way to use a variable subroutine name? I've a vague memory that there used to be a way to do that in Basic, but I'm not sure it's in VBA.