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

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

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