How do I open multiple hidden worksheets all at once?

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
Samurai@discussions.microsoft.com> wrote:

>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?

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

"Gord Dibben" wrote:

> 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
> Samurai@discussions.microsoft.com> wrote:
>
> >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?
>
>

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
Samurai@discussions.microsoft.com> wrote:

>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?

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

"Gord Dibben" wrote:

> 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
> Samurai@discussions.microsoft.com> wrote:
>
> >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?
>
>

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?

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
Samurai@discussions.microsoft.com> wrote:

>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?

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

"Gord Dibben" wrote:

> 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
> Samurai@discussions.microsoft.com> wrote:
>
> >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?
>
>