Ok all I’m getting is #VALUE! errors but I notice that on this line:
“If sht.Cells(1, j) = pMonth Then 'This says ROW 1,COLUMNS C THRU N”
The code when debugged never goes pass this line. It won't let me attach a picture of the results.