ExcelBanter - How can I create a worksheet using Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I create a worksheet using Macro (https://www.excelbanter.com/excel-worksheet-functions/72916-how-can-i-create-worksheet-using-macro.html)

Krishnan

How can I create a worksheet using Macro

I am a beginner; I need to generate a new worksheet and rename the new work
sheet; Please help me out in this

Norman Jones

How can I create a worksheet using Macro

Hi Krishnan,

Try:

'=============
Public Sub Tester003()
ActiveWorkbook.Sheets.Add.Name = "Krishnan"
End Sub
'<<=============

---
Regards,
Norman

"Krishnan" wrote in message
...
I am a beginner; I need to generate a new worksheet and rename the new work
sheet; Please help me out in this

All times are GMT +1. The time now is 04:50 PM.