ms excel programing using vba

[neo2083]

how to create a new sheet (i.e.) one more & where to write
the code in which sheet coding?

 

[IRstuff]

The menu Insert|Worksheet item allows you to add sheets to a workbook.

Macros are associated with the workbook, not with the worksheet.

TTFN

 

[LyMc]

The easiest way to determine this is to turn on macro recording, do the action, turn off recording and go look at the macro created.

 

[neyer]

This method works as a good place to start, but there are a number of Excel commands that are not recorded. Also, you should look at the help for that object because they way that the Macro recorder works is most often in my experience not the way that I need it to work. Thus, I often use this method only to get an idea of what I should do.

 

[mjs84]

The command:

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