Array Code to Delete Worksheets
I am using some code to create arrays based on the value of a cell. Works
just great. Now I need to figure out how to use the same value to create case
values that can make array's to delete some different cells. As an simple
example:
Cell a1 is A or b or c etc
Code sets up arrays to display only certain sheets ie
a = (sheet1,sheet4,sheet5)
b=(sheet22,sheet23,sheet24)
For the same a or b, i want to delete some sheets (but not all others) as
well.
Can anyone please make a suggestion on this.
Thanks in advance.
|