How do I open multiple hidden worksheets all at once?

[Guest]

I know how to hide multiple worksheet by tagging them. How do you open
multiple worksheets all at once rather than having to do them individually?

 

[Gord Dibben]

Last

VBA macro.........

Sub Show_Sheets()
Dim i As Integer
For i = 1 To ActiveWorkbook.Worksheets.Count
ActiveWorkbook.Worksheets(i).Visible = True
Next i
End Sub


Gord Dibben Excel MVP


On Thu, 14 Jul 2005 13:18:15 -0700, Last Samurai <Last

 

[Guest]

Why is this giving me an error? It doesn't make sense!!!!

SUMPRODUCT(--('Raw - 2nd'!$C$2:$C$65536=$A37),--(MONTH('Raw -
2nd'!$b$2:$b$65536=4),'Raw - 2nd'!$J$2:$J$65536)

Column c is employee number
Column b is date range
Column j is $$ range

Any help is appreciated. Hopefully I have not broken any rules by jumping
in this string