Posts by Eagle04

    Re: VBA runtime error '6': Overflow

    I'm having a similar issue to this and was hoping to get some assistance. I am also receiving a run-time error 6 Overflow error and can't identify what's causing this. Below is my code:

    The line RecentMonth = Workbooks(wb).Sheets("Full File July").Range(Cells(12, 1), Cells(SheetLastRow, SheetLastcolumn)).Value is what is causing the error. There are only 21 columns in the sheet so I don't think the Byte assignment should be an issue(?) Any insights would be much appreciated!