G
Guest
Guest
Hi all,
I am doing an A-level piece of coursework in excel and am stuck. I have a button that copies a worksheet, adds a new worksheet, and then into that newly added worksheet it pastes the previously copied data....
So it basically makes a replica of the original sheet.
This is all ok, but i want it to rename the created sheets accordingly...
So that the first copy made is renamed 'standard window 1', then the next time the button is pressed i want it to rename the sheet 'standard window 2'..etc
I dont think this is particularly hard but i havent figuyred it out yet and am getting a bit panicky, the dealine is ever advancing!!!
Please can some one tell me how, i dont mind a bit of VB as i assume this is the only way..
Thanks in advance. If u would rather email me yer comments my address is mhouldey@yahoo.co.uk
Cheers,
Mike Houldey :|
If only...
I am doing an A-level piece of coursework in excel and am stuck. I have a button that copies a worksheet, adds a new worksheet, and then into that newly added worksheet it pastes the previously copied data....
So it basically makes a replica of the original sheet.
This is all ok, but i want it to rename the created sheets accordingly...
So that the first copy made is renamed 'standard window 1', then the next time the button is pressed i want it to rename the sheet 'standard window 2'..etc
I dont think this is particularly hard but i havent figuyred it out yet and am getting a bit panicky, the dealine is ever advancing!!!
Please can some one tell me how, i dont mind a bit of VB as i assume this is the only way..
Thanks in advance. If u would rather email me yer comments my address is mhouldey@yahoo.co.uk
Cheers,
Mike Houldey :|
If only...