I have been searching for something like this for days! So thanks for getting me on the right track.
However, Is it possible to adjust your code so that it is a manually executed macro (attached to a click button for example)?
I am building a spreadsheet with other macros that crash when I use yours, I assume because it is automatic.
I've tried augmenting your code so that it is a regular macro (as opposed to a sheet's code) But i'm very amateur!
Any advise/feedback would be greatly appreciated.