I tested it, it works fine if you drop "myWB." from in front of
the "Application.WorksheetFunction..." statement. (Also if you have set
Option Explicit don't forget to declare txtTot as string.)