Good afternoon,
After battering my head all afternoon with various permutations of the below, I'm conceding defeat and throwing myself on the mercy of the Excel Gods
Dim StatsSheet As Worksheet
Set StatsSheet = Worksheets("Stats")
Dim TransSheet As Worksheet
Set TransBook =...