So I have a macro, very simply recorded which sorts the data on various worksheets within a workbook. When someone changes the name of one of the worksheets the macro breaks, as it is looking for the old name, not the new one. Is there away that the macro can be updated automatically with the name change of the worksheet, as normal excel formula references would?
Unfortunately I suspect not, but if you don't ask you don't find these things out.
Many thanks
Unfortunately I suspect not, but if you don't ask you don't find these things out.
Many thanks