Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok the object of this code is that once it is done running that It will
cumulatively Select all sheets in a workbook that are NOT named "STable" or "SChart" much in the same way as if you were to manually hold down the Cntrl button and start clicking (selecting) multiple sheets with in a workbook Why doesn't this work ? here is my code: Sub Test() Dim y as integer Dim t as interger For y = 1 To SheetCount If Not Sheets(y).Name = "STable" Then If Not Sheets(y).Name = "SChart" Then t = t + 1 ReDim Preserve SheetsToDel(t) SheetsToDel(t) = Sheets(y).Name End If End If Next y For y = 1 To UBound(SheetsToDel()) If y = UBound(SheetsToDel()) Then StrA = Chr(34) + SheetsToDel(y) + Chr(34) Else StrA = Chr(34) + SheetsToDel(y) + Chr(34) + "," End If StrB = StrB + StrA Next y Sheets(Array(StrB)).Select End Sub This doesn't work and yet if I just try this line of code: Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select It works. My StrB is the same thing as manually typing in the string the the line above so what gives any thoughts ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleteing objects | Excel Discussion (Misc queries) | |||
deleteing documents | New Users to Excel | |||
Deleteing | Excel Discussion (Misc queries) | |||
deleteing duplicates | Excel Discussion (Misc queries) | |||
Deleteing Rows | Excel Programming |