Thread: Worksheet name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
achidsey achidsey is offline
external usenet poster
 
Posts: 100
Default 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