Hi ya'll and good morning,
First problem of the day,
I need some VBA code to help me rename the TAB (Of the Worksheet) to a Cell....
However i only want to rename the Sheet Name to the first 12 chracters of the Cell containing the string...
So for example in A1 it has Missing_Data_&1234_*Hello_%goodbye
Because you cant use special chracters on the names of tabs i only want to return the first 12 chracters so it would basically be 'Missing_Data'
First problem of the day,
I need some VBA code to help me rename the TAB (Of the Worksheet) to a Cell....
However i only want to rename the Sheet Name to the first 12 chracters of the Cell containing the string...
So for example in A1 it has Missing_Data_&1234_*Hello_%goodbye
Because you cant use special chracters on the names of tabs i only want to return the first 12 chracters so it would basically be 'Missing_Data'