I have had the weirdest issues with macro's. If you have a target in the macro, somewhere it get's cached and it doesn't refresh like you would think it would. Try to recreate the macro, maybe that helps. It has helped me twice already.