Yes, it did show as "ThisWorkbook.total"....

I was able to do some trial-and-error troubleshooting on
it last night and believe I found the solution. It's hard
for me to say exactly what the problem was, because of the
way I was approaching the problem.

I do appreciate your help.
Rich

-----Original Message-----
Something is not right. For one thing, if Sub Total is
in ThisWorkbook then
it would appears as "ThisWorkbook.Total" not "Total" in
the Macros dialog.