|I see no reason for it to be throwing up an error on that particular line.|
In fact I just copied that line, all by itself and put it in macro and it didn't return an error.
Set endMonth = Sheets(1).Rows(1).Find(Month(eomonth(Now, 2) + 1) & "/1/" & _
Year(eomonth(Now, 2) + 1))
Granted, it didn't find what it was looking for, so endMonth = Nothing, but it didn't throw up an error, nor would I have expected it to.
Are you sure that's where it's throwing up the error?
There are multiple types of run-time errors. What does the text of the error say?