Welcome to the VanDyke Software Forums

Join the discussion today!


Go Back   VanDyke Software Forums > Scripting

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 06-01-2019, 10:16 PM
Bruno74 Bruno74 is offline
Registered User
 
Join Date: May 2019
Posts: 4
VBS Delete all empty sheets

Hi,

I am looking for a VBS code which deletes all the empty sheets in my workbook.
Tks
Reply With Quote
  #2  
Old 06-03-2019, 12:21 PM
jpellegrini jpellegrini is offline
Registered User
 
Join Date: Mar 2019
Posts: 20
Hi Bruno74,

Looking at the following links should provide you with an idea of how to remove blank sheets in an Excel workbook.

https://stackoverflow.com/questions/...rows-using-vbs

https://www.thespreadsheetguru.com/t...kbook-with-vba

I have not tested this code, nor can I verify that it will work and not have unintended consequences to your workbook. Since we cannot provide custom script support, this is provided without guarantee, BUT the information may help you find a way to remove blank worksheets.
__________________
Thanks,
--Jon

VanDyke Software
Technical Support
support@vandyke.com
(505) 332-5730
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 01:05 PM.