| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a new sheet in VBA?
Hi,
I need a code to create a new sheet in the VBA. Sheets.add is opening in between the existing sheets. For eg. I have Sheet1,Sheet2,Sheet3 IN this case i if open the new sheet it is opening inbetween th Sheet1 and Sheet2 where i need to open after the sheet3. I feel that it is possible to do. Can you help me out ? Thanks in advance Regards Venku -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create a new sheet in VBA?
Hi Venku
Try: ActiveWorkbook.Sheets.Add After:=Worksheets("Sheet3") -- Best Regards Leo Heuser Followup to newsgroup only please. "kvenku " skrev i en meddelelse ... Hi, I need a code to create a new sheet in the VBA. Sheets.add is opening in between the existing sheets. For eg. I have Sheet1,Sheet2,Sheet3 IN this case i if open the new sheet it is opening inbetween the Sheet1 and Sheet2 where i need to open after the sheet3. I feel that it is possible to do. Can you help me out ? Thanks in advance Regards Venku. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create Login & Log out Spread sheet in Excel with automated Attendance sheet | Excel Worksheet Functions | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| How to create a formala in one sheet for a cell in another sheet? | Excel Worksheet Functions | |||
| How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
| How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming | |||
![kvenku[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
