So it it possible to cycle through the array before creating all the worksheets and removing the value Encyclopedia without leaving a sequencing gap in the arrary. The problem is that if I delete the worksheet when I reference the array later the array still has the value Encylcopedia in it. The report I am working on right now happens to have the value Encyclopedia so I was wanting to delete the worksheet. Encylopedia can show up anywhere in the list or not at all. When this finishes running I get the following:Īs a result of the above code I end up with a workbook with 7 worksheets in it all named with one of the above values. Worksheets(First).Copy before:=Sheets("ExpSheet1")Įverything that is is our software's code. ![]() of Items " & strDate-12 & " and newer"Ĭells(6,4).value = "(" & strDate-6 & " and older for encyclopedias)"Ĭells(6,5).value = "(" & strDate-5 & " and newer for encyclopedias)"Ĭells(1, 1).Value = Title & " Collection Worksheet" ![]() of Items " & strDate-13 & " and older"Ĭells(3,5).value = "No.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |