Help with vba coding debugging - I just cant see where I am going wrong ;(

I think I have been staring at this too long - just cant see where I am going wrong with the coding below. The whole spreadsheet is aimed at helping the teachers at my school with their tracking etc.

Sheets 26 to 28 have either M or F in Column G, which is filtered in the first part of the coding.

If I run it with 'M' as criteria it works great, as soon as I change to 'F' it does all I ask, but I get a RunTime Error 13 'type mismatch' and the end.

YET if I run Part 1 and Part 2 separately they work well.

Any ideas?

Thanks

Please Login or Register  to view this content.

It is too big to attach

Can I link to an external copy on googledrive or something?

I have uploaded to here as too big for Excel Forum. I hope that is allowed.

HTML Code: 

Zipped it is still 1.7mb which is too big.

The macro applies to all sheets, I suppose I could edit it down to a sample for you...

AHA!

While simplifying to upload for you guys to see I spotted and corrected the issue!

Thanks.....while you only helped indirectly, you actually helped me solve it for myself!

Ha

The loop was referencing a sheet without the M/F on it. Not sure why it worked with the M - should have failed on both.

Please Login or Register  to view this content.

should have read

Please Login or Register  to view this content.