How do I create and new sheet tab, and name it with whatever the value is of the active cell?
I recorded the following and even with the "Use Relative References" on, it still used static values when I tried to copy and paste in the sheet tab renaming...
'I am starting the process with a cell selected that
'will become the new sheet tabs name. I copy the cell
'and Ln3 is the paste into the sheet tab rename.
Sheets("Sheet3").Select 'will be different each time
Sheets("Sheet3").Name = "120-2758" 'will be different each time
Application.CutCopyMode = False