Below sub procedure will delete 2 sheets with name sheet2 and sheet3
Sub multiple_worksheets()
'We can select multiple worksheets by using below syntax
Worksheets(Array("Sheet2", "Sheet3")).Select
'We can also delete multiple sheets at the same time
Worksheets(Array("Sheet1", "Sheet2")).Delete
End Sub
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible.
I value your opinion on Excel Macros.
Sub multiple_worksheets()
'We can select multiple worksheets by using below syntax
Worksheets(Array("Sheet2", "Sheet3")).Select
'We can also delete multiple sheets at the same time
Worksheets(Array("Sheet1", "Sheet2")).Delete
End Sub
No comments:
Post a Comment