24 | 05 | 2017

Add a worksheet

Sub AddWorksheet(ByVal ShtName As String)
 
'****************************************
'*** Code from VisibleVisual.com ********
'****************************************
 
Worksheets.Add().name = ShtName
 
End Sub

Or if you would likt to place the worksheet on a specific location use

Worksheets.Add(Before:="Sheet3", After:="Sheet2").name = "NewSheet"
Login

Sign up now and upload your code to the website.

Help us to continue.....
Statistics
Articles View Hits
2258981
Latest Articles