Worksheet name
Excel Experts,
I have a workbook which has a sheet named "BskTrades". I want my code to
add a new sheet after BskTrades and name it "BskTotals".
My code adds a new sheets after BskTrades but fails on the second line which
I want to name the new sheet "BskTotals".
What do I have wrong?
Sub AddSheet()
Sheets.Add After:=Worksheets("BskTrades")
Worksheets(Worksheets("BskTrades").Count + 1).Name = "BskTotals"
End Sub
Thanks in advance,
Alan
--
achidsey
|