Тёмный
No video :(

Delete Multiple Sheets Quickly Using Excel VBA 

Noah Stelting
Подписаться 645
Просмотров 2,9 тыс.
50% 1

If you have a Excel file with lots of sheets, here is a quick script to delete multiple sheets at a time using Excel VBA.
Sub deleteSheets()
Dim ws As Worksheet
Application.DisplayAlerts = False
For Each ws In Worksheets
If (InStr(ws.Name, "2022") = 0) Then
ws.Delete
End If
Next ws
Application.DisplayAlerts = True
End Sub

Опубликовано:

 

27 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 3   
@noahstelting
@noahstelting Год назад
Please let me know if you have any questions or feedback about the video. Thanks for watching!
@BleughBleugh
@BleughBleugh Год назад
Thanks for this quick bit of code. Gave me a laugh when i copy / pasted it and it deleted only the stuff I wanted to keep! ...Quick change to "2022") = 0) to =1 and voila, worked a treat, thankyou!
@noahstelting
@noahstelting Год назад
No problem, glad this was useful for someone!
Далее
😭Телеграм УДАЛЯЮТ❌
00:50
Просмотров 55 тыс.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
VBA Macro to Copy Data from Another Workbook in Excel
13:39
Send Multiple Emails From Excel
10:09
Просмотров 71 тыс.
How to Use the IFS Function in Excel
11:01
Просмотров 347 тыс.