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

Hello
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?

Regards
Yiota

RE: Run Time Error - Object Defined error

Hi,

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.

Claire

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.