Macro works on 365 but not 2010

[Dazzawm]

I have a macro that works fine on my 365 and a colleagues also. Another colleague that has Office 2010 and when he runs it it comes up with Compile error: Syntax error.

Is this common? Do macros work on some office versions but not others?

Any help appreciated.

 

[Joe4]

Add2 will not work in 2010.

Thanks for confirming that, Rory.
I was pretty sure that was the case, but no longer have access to Excel 2010 to confirm.

 

[RoryA]

It won't work in 2016 or earlier either.

 

[Joe4]

I think I changed to Add anyway which threw up another overflow error which made me think about the integer and long.

It is important to understand how big your variables may get, and the limitations of each variable type, so as to not run into problems.
See here: Data type summary

When using a variable to store something like row number, I always use "Long" as that is big enough to handle any row number on the sheet, while "Integer" would only handle up to 32,767, as Excel has more rows than that.

 

[Dazzawm]

Much obliged for everyones time.

 

[MARK858]

What difference would the add and add2 of made anyway?

Add2 can sort the new data types like Stocks and Geography, Add can't.