Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I have this listed in my code and it works fine when I remember to
delete the sheet and it can be replaced. However there are times I don't succeed in getting to that place and hope I can get an answer. If the "Rejected Voucher Statistaics" sheet exists I need to delete the sheet from the workbook so the new "Pivot Table Sheet" can be moved seemlessly and named the same. I would like to 1. Iheck and see if it exists 2. If it doesn't continue 3. If it does exist, delete it and continue with the macro.. ActiveSheet.Name = "Rejected Voucher Statistics" Thanks BOBR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA for deleting a sheet | Excel Programming | |||
Deleting sheet | Excel Programming | |||
Deleting a sheet | Excel Programming | |||
Deleting Sheet | Excel Programming | |||
Deleting a Sheet | Excel Programming |