I want to create a macro, linked to a button, that creates a new worksheet and then moves it to the end of the worksheet list.
I've tried recording a macro and then looking at the code but I can't seem to edit it to make it do what I want. I assume I'll have to use the 'xllast' command somewhere but whenever I try to include this in the code I get errors.
Anyone got any ideas?
Cheers
-Rob
