98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · Medium Priority · Version 2016
Mon 23 Mar 2020, 09:30Delegate Yiota said...
Yiota has attended:
Access Introduction course
Access Intermediate course
Excel VBA Introduction course
Excel VBA Intermediate course
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
Mon 23 Mar 2020, 16:24Trainer Claire said...
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move or Highlight CellsUse 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. |
