Rockhopper3
Board Regular
- Joined
- Apr 11, 2006
- Messages
- 131
I have a formula that adds 1 to a numbe. This number then replaces another number in the worksheet name. When VBA adds the numbers, it takes away the zero in front of it. Does anyone know how to solve this so the sheet name will display as Jan.-07, etc?