Hi,

I inherited workbook which has macros which work OK in Excel 2010, but fails in 2013 with an error:

Run-time error '5':
Invalid procedure call or argument
The debug shows the problem as code (extract):
Please Login or Register  to view this content.
It's finding a reference number in a list of the format AA12345, runs through row by row (i) and strips off the first two characters.
The second line is shown as the error.

Has syntax changed in 2013?