Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a new worksheet?
Hi, Just wondering how I could create a new worksheet from within a macro? Cheers Sahil EDIT: I'd also like to know how to create new workbooks from a macro and how to name the individual workbooks/worksheets -- schouja ----------------------------------------------------------------------- schoujar's Profile: http://www.excelforum.com/member.php...fo&userid=2657 View this thread: http://www.excelforum.com/showthread.php?threadid=40068 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a new worksheet?
Sheet ActiveWorkbook.Sheets.Add Befo=Worksheets(Worksheets.Count) Workbook Workbooks.Add Check VBA help, type ADD, and press F1 Manges -- mangesh_yada ----------------------------------------------------------------------- mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047 View this thread: http://www.excelforum.com/showthread.php?threadid=40068 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a new worksheet?
use a worksheet object for greater control...
DIM ws as Worksheet SET ws = worksheets.add with ws .Name = "myNewSheet" .Range("A1") = format$(Date,"dd-mmm-yy HH:MM") end with "schoujar" wrote: Hi, Just wondering how I could create a new worksheet from within a macro? Cheers Sahil EDIT: I'd also like to know how to create new workbooks from a macro. and how to name the individual workbooks/worksheets? -- schoujar ------------------------------------------------------------------------ schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574 View this thread: http://www.excelforum.com/showthread...hreadid=400685 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Worksheet | Excel Discussion (Misc queries) | |||
Creating an inventory worksheet | Excel Discussion (Misc queries) | |||
Creating a worksheet in Spanish | Excel Discussion (Misc queries) | |||
Creating a Worksheet in VBA | Excel Programming | |||
Creating a new worksheet from another | Excel Programming |