Unfortunately it did not.
Your code earlier had worked except it needs to define the sheet where the changes will be made in this the sheet is called "data" such that the user does not have to be on the 'data' sheet to run the macro, it can be run from a different sheet. If I was the sole user of this file, it wouldn't matter, but other users of the file want to just hit a button on one sheet that has all the different macros to do whatever they want it done on other sheets. Hope this makes sense. Thanks.