Creating a new worksheet?

[schoujar]

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?

[mangesh_yadav]

Sheet

ActiveWorkbook.Sheets.Add Before:=Worksheets(Worksheets.Count)


Workbook

Workbooks.Add


Check VBA help, type ADD, and press F1



Mangesh

[Patrick Molloy]

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
>
>