Thread: Insert sheet.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre[_17_] Pierre[_17_] is offline
external usenet poster
 
Posts: 8
Default Insert sheet.

Wy get a and error
CompileError:
can find the method or the fact member?

Sub TabbladRechtsInvoegen()
' Find how many sheets are in the workbook
Dim No_Sheets
No_Sheets = Sheets.Count
' Add a new sheet
Sheets.Add
' The new sheet is the active sheet. Move it to after the last Sheet
ActiveSheet.Move After:=Sheets(No_Sheets + 1)
End Sub

JP