Run-time error '424' - Object Required HELP

Hi. I have minimal experience with VBA, and received a lot of help from another forum (can't remember which one, hence why i signed up here) in order to build it. I've since modified it to fit my needs for my project I'm running this year. Slightly different export requirements etc. So, while I know there may be 'better ways' to write what I'm trying to do, you'll end up confusing me more I will take the time to learn the better ways later, but for now, I have an export I need to have finalized by EOW.

I can't show the actual spreadsheet for confidentiality reasons, but was hoping someone could help me debug this. The error I get is in the title of the post, and I've gone through the code several times and can't identify why it's not working. I had it working perfectly on Friday, and hadn't touched anything. When I did my morning export (again, haven't touched or changed anything since Friday- including the document I'm exporting from. nothing has changed..)- it gave me the error and highlighted the item below. If i remove the item entirely, it gets hung up on the next one. Can someone help?

It gets hung up on the red text. If I remove the whole thing, and re-run, it will get hung up on the item in blue. it's incredibly confusing considering I've done nothing different since Friday afternoon

Please Login or Register  to view this content.

Thanks!
Eric

try this

Please Login or Register  to view this content.

can't be sure it will work without the original spreadsheet but give it a try

(not sure why it didn't respond a second ago, so apologies if this posts twice). Tried the above, and now it gets hung up on red text below. Also, apologize, I know it's easier with an actual spreadsheet- but appreciate the attempt to help without one.

Please Login or Register  to view this content.

if col6 a text variable? if so replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

You are basically getting this issue because your variables/objects were not properly dimensionalized. but you're on the right track.

Successfully ran.

Definitely appreciate your quick replies and assistance. When I have time, I will reply again to better understand exactly what those lines do that you added.

For now- you are the best!
Thanks
Eric

all good.

If you like the solution, consider adding to my reputation (link on the left)

Best of luck