Something like:
To insert the above right click on tab against which the code is to be applied - select View Code and insert into resulting window thereafter ensure Macros are enabled.

Originally Posted by
MGK086
I also need this macro to work to work it the worksheet is coppied into the same workboob multiple times.
if you right click on tab and select to Copy you should find the code will fire on the replica sheet also (separate events - ie the copied sheet does not affect original and vice-versa)
Bookmarks