View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Volsfan Volsfan is offline
external usenet poster
 
Posts: 7
Default 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.