I need to rename all worksheets of the active workbook (with the exception of one worksheet named 'DataSource') ...
... based on the cell value B2 of the respective worksheets
The trouble is that these cell values in B2 all contain one illegal character, ie. a forward slash '/' such as F/123 or G/497
Is it possible to replace this illegal character with an 'underscore' character, so that the worksheets name have names like
... F_123, G_497, T_587 etc.
The cell values have to be left alone, they should retain the forward slash.
Could somebody please come up with such a VBA code.
Help is very much appreciated. Thank you very much in advance.