L
LabrGuy Bob R
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
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