Thank you so much for this post - this was exactly what I was looking for. However, when other users try to run the macro on our company network, they are getting an error code (Error 1004 “Application-defined or Object-defined error”). Any idea how to resolve?