dcwinter
Board Regular
- Joined
- Aug 10, 2007
- Messages
- 118
Hi,
As part of a macro, I have copied a sheet within a workbook, and I want to rename that sheet as the value in Cell B3.
This will mean that a new sheet can be created for individual customers.
I don't know how to do this - I tried to simply copy the value in cell B3 and then paste it into the tab name at the bottom of the sheet as a recorded macro, but that doesn't work.
Any ideas???
:x
As part of a macro, I have copied a sheet within a workbook, and I want to rename that sheet as the value in Cell B3.
This will mean that a new sheet can be created for individual customers.
I don't know how to do this - I tried to simply copy the value in cell B3 and then paste it into the tab name at the bottom of the sheet as a recorded macro, but that doesn't work.
Any ideas???
:x