So in words, each time the macro runs it copies A1:A49 from sheet "% s" into the next empty column of Peak Statistics starting at row 9 pasting as values only?
Correct. I don't think this poses a problem, but there are also "spacer cells" (empty cells) on sheet "%s".

I tried your code, same result. I verified that it did in fact copy the data as I could paste it after running the macro, but the macro itself does not paste anything. Below is an example of what it "should" paste from cells A1:A49 from sheet "%s":

0%
0%
0%

49%
46%
46%


464230
485672
485230

0
0
0
0
0
0
0
1
712
868
541
164
146
57
125
100


1.2%
4.2%
0.6%
0.6%
0.0%
3.9%
2.6%
0.9%
1.3%


4.0%
4.4%
9.3%
1.5%
0.0%
0.1%
0.0%

Thanks for the help here.