I gave that a try to no avail. Am i crazy or am i just VBA impaired? It looks like your code is identical to mine except for the "application.screenupdating = false" and "application.screenupdating = true" at the beginning and end of the code. I tried to paste to column M in "MasterSheet" by changing "cells(r,1).select" to "cells(r,13).select"and i get same error..... error1.PNG. Or am i doing something completely wrong?