To create a new worksheet in Excel, you need to write
Dim WS As Worksheet Set WS = Sheets.Add WS.Name = "Mukesh"
or you can also write this as in old fashioned way, but first method is recommended
Sheets.Add.Name = "Dak"
Excel – Create New Worksheet
Article by Mukesh Dak
Mukesh has written 253 awesome articles for us.
If you liked this post, you will definitely enjoy our others. Subscribe to the feed via RSS or EMAIL to get instantly updated for those awesome posts soon to come.
Previous post: Find Last used row in a Worksheet
Next post: Submit Variable to self
