Hey,
I was wondering how to take a value stored in a cell, and then rename the sheet to that value using VBA.
Algorithm:
1. Copy Sheet1 at end of book
2. Select Sheet1, cell A1
3. Copy cell A1
4. Rename Sheet1Copy to cell A1.value
Thanks,
DaVuLF
I was wondering how to take a value stored in a cell, and then rename the sheet to that value using VBA.
Algorithm:
1. Copy Sheet1 at end of book
2. Select Sheet1, cell A1
3. Copy cell A1
4. Rename Sheet1Copy to cell A1.value
Thanks,
DaVuLF