run time error

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Run Time Error - Object Defined error

Run Time Error - Object Defined error

resolvedResolved · Medium Priority · Version 2016

Run Time Error - Object Defined error

I am running this advanced filter code and I'm now getting a run time error, it used to work before, I had around 50 row, I have now added more rows 6000 in total.

.Range("i15:HV" & LastResultsRow3 + 9).Value = Sheet2.Range("AJI4:ARV" & LastResultsRow3).Value

any ideas? or how I can get around it?


RE: Run Time Error - Object Defined error


First thing to check with Advanced Filter is that you're not including any empty rows in the filter criteria. If you are then it interprets that as part of the filter and you end up with all the data.

Can you check you've got the right cell range?

If there's still a problem we can dig a bit deeper.


Mon 30 Mar 2020: Automatically marked as resolved.


Training courses


Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips

Server loaded in 0.07 secs.