kreilly1243
New Member
- Joined
- Jan 6, 2023
- Messages
- 1
- Office Version
- 365
- 2021
- Platform
- Windows
Hello,
I am currently working on a workbook that requires values from a selected range be cut and pasted to another existing sheet. I want to be able to move any accounts less than 60 days past due to the next empty row on the 30 days past due sheet. The macro is doing everything I want it to EXCEPT finding the next empty cell of my table on the "30 DAYS" sheet.
I have attached a screenshot of the current VBA, and it is failing at the Selection.Range("Accts30Days").Rows.Count.End(xlUp).Offset(1).Select line. The error message I am recieving is: Run-time error '424': Object required.
I am frustrated to tears... I've tried everything.. Someone... anyone please help me.
Thank you!
I am currently working on a workbook that requires values from a selected range be cut and pasted to another existing sheet. I want to be able to move any accounts less than 60 days past due to the next empty row on the 30 days past due sheet. The macro is doing everything I want it to EXCEPT finding the next empty cell of my table on the "30 DAYS" sheet.
I have attached a screenshot of the current VBA, and it is failing at the Selection.Range("Accts30Days").Rows.Count.End(xlUp).Offset(1).Select line. The error message I am recieving is: Run-time error '424': Object required.
I am frustrated to tears... I've tried everything.. Someone... anyone please help me.
Thank you!