Upon error, skip and continue

[Smally]

Hello. I use a spreadsheet for renaming a load of files at once.

My code goes through all cells from J5 to J500, this is the current file name. The new file name is in column K

Please Login or Register  to view this content.

The problem I'm having is when I encounter an error. For example I sometimes get Error 58: File already exists.
How do I change my code so if I encounter an error, skip the renaming, and move onto the next cell and continue

[alansidman]

On error resume next

https://msdn.microsoft.com/en-us/library/5hsw66as.aspx

[Smally]

Ah thanks, if only all my vba problems were this easy to fix.

Is there a way to determine what to do depending on what error message it is.
For example, if error 58, put 1 at end of filename. If same error occurs again, put 2 at end of filename etc. etc.

[alansidman]

Have you tried adding and Elseif line to your code.