*Resolved* Macro for Excel

[TheRobster]

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

[BrianB]

Sheets.Add after:=Sheets(ActiveWorkbook.Sheets.Count)

[TheRobster]

Cheers Brian, that works a treat.