Nevermind, I figured that if you have an empty gap in the data thats in the end column, the macro wont run there. Thanks for the help!