Good evening yawnzzzz

Not tested, nor can I test it as I don't have Excel 2010 however I think you're going to need two versions of the macro: one for 32 bit and one for 64 bit. You will need to read the Application.Version value to see what the user is running and run the appropriate version.

HTH

DominicB