TmpltNum.xla is the template addin. In Excel choose Tools - Addins -
Template Utilities. This will install the addin and clear up the missing
reference...
--
HTH...

Jim Thomlinson


"Casey" wrote:


Jim,
Your clarivoyance (Option Explicit thing) and your code were both right
on. Thank you. Follow up if I may. What would be the correct Declaration
for Msg?

Bob,
Thank you for your input as well. I did go to ToolsReferences and low
and behold, a checked reference to TMPLTNUM.XLA is preceeded by
MISSING:.
What should I do here?

Thank both of you for your time.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=395380