Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a blank sheet in a workbook
Hi all. I've got a VB program that is eporting SQL data to a workbook. It loops to create a new sheet for every employee. It's working well... but I still have some format issues to overcome. I'm ok with VB, but the Excel syntax is all new to me as of this project. As my code creates a new sheet first before checking for the next employee, it finishes by adding a new sheet to the very end of the workbook. I tried using: *ActiveWindow.SelectedSheets.Delete* Unfortunately, the program is jumping back to the first sheet before deleting. This doesn't work well anyway, because finishes the code out by prompting the user is s/he wants to delete before deleting. Is there a way to search the active workbook and delete any sheets than contain no data? Thx! -- wolfdogg ------------------------------------------------------------------------ wolfdogg's Profile: http://www.excelforum.com/member.php...o&userid=25269 View this thread: http://www.excelforum.com/showthread...hreadid=387569 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting the blank rows from the sheet | Excel Worksheet Functions | |||
Deleting all but one blank row | Excel Discussion (Misc queries) | |||
Deleting Blank Rows | Excel Programming | |||
Deleting Blank Rows | Excel Programming | |||
Deleting every sheet in workbook after Worksheets(4) | Excel Programming |