ms excel programing using vba
ms excel programing using vba
(OP)
how to create a new sheet (i.e.) one more & where to write
the code in which sheet coding?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
ms excel programing using vba
|
RE: ms excel programing using vba
Macros are associated with the workbook, not with the worksheet.
TTFN
RE: ms excel programing using vba
RE: ms excel programing using vba
RE: ms excel programing using vba
'ActiveWorkbook.Worksheets.Add'
will add a sheet before the active worksheet in the active workbook.
'Worksheets.Add.Move after:=Worksheets(Worksheets.Count)'
will add a sheet and move it to the end of all visible worksheets.
To get to the VB editor, go to 'Tools + Macro + Visual Basic Editor'.