Quote Originally Posted by Paul_Hossler View Post
Try just

lastrow1 = Range("K" & sh1.Rows.count).End(xlUp).Row

Good Suggestion, but the result was the same. I don't think this is as big of a priority as I was making it, my boss doesn't seem concerned about the bug, as he pointed out that anyone doing the Analysis should not expect to see any values of "0". Although, for my sanity, I do want to still solve this as it reflects on the creator if anyone were to happen across this bug.

So please, keep them coming lol.

Thanks!