I have a code that I have tested out and have successfully done what I needed it to do. In general, it grabbed all the ranges, txt and info I supplied in an excel worksheet and made it into a rpt file in which I submitted for testing and got a successful result.

Problem: I moved this code to a newer spreadsheet. The spreadsheet has the same needs as my test one. Difference, I now have 5 worksheets associated to the Sheet one. From those 5 worksheets all the info is linked back to Sheet one and assigned to the cell that a grand total needs to come from. I ran the code and the common issue I am finding for the "type mismatch" error is once it hits the cell that contains a link to a cell that has a formula it stops. Can this be an issue?