Object doesn't support...on certain computers

[gcerulli]

Dear All,
I am a self taught VBA user and I'm sure my code is inefficient and sloppy but I usually end up getting it to do what I want. I've run into a snag and I'm completely lost. The following macro is a called macro that runs as intended on my machine. When my boss tries to run it (it's a tool for him) he gets the following error: "Object doesn't support this propery or method". I've run it step by step on his machine and I think I've identified where it fails.

(FYI I am using Excel 2016 and he's using Excel 2013)

***UPDATE - I tried it on another coworker's machine with Excel 2016 and it worked find there as well

***UPDATE #2 - It also worked on a coworker's machine with Excel 2019.

Thanks in advance for your assistance.

Please Login or Register  to view this content.

[AlphaFrog]

I've run it step by step on his machine and I think I've identified where it fails.

Care to share what line it errors on. Might be a clue.

[gcerulli]

I should have been clearer. Sorry.

It's denoted in the code itself:

'the next line is where it fails

[frabulator]

What version of Excel is on your bosses computer?
*EDIT*
Sorry, 2013, got it (glanced over that)

[frabulator]

Your problem is in Excels older VBA structure. Over the years Microsoft has changed a few things. 'Add2' was one of them. In older versions it needs to be just 'Add', while in newer versions it needs to be 'Add2'. Please see below. I have modified your code a little and added an if statement to check for version differences.

Please Login or Register  to view this content.

[AlphaFrog]

This should be compatible with all Excel 2003 and later versions

Please Login or Register  to view this content.

[gcerulli]

These both worked! Thank you so much.

It also prompted my boss to upgrade to office 2019, so I guess Microsoft wins as well.

It's a good day when you learn something new.

This community always bails me out when I am at the end of my rope.

Thanks!