| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert sheet tab is not functioning and can't add new sheet | Excel Worksheet Functions | |||
| Insert Sheet | Excel Worksheet Functions | |||
| insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
| Insert Sheet | Excel Programming | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
![Pierre[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
