Hi,
I am currently working on a macro in regards with the renaming of the sheets.
I am having a problem with the renaming of multiple sheets based on a cell. The code that I am using does not rename all the sheets based on the Range "B1".
Below is my code:
for example :
In Range A1 there is a name "Kaname (10036660)"
Then on Range B1 Right function will be used to get the "10036660"
The parentheses should not be included.
Could you please help me because its been 5 days already and I can't seem to solve it.
Bookmarks