Select Case for Active Worksheet syntax.

[mikeburg]

I need help arriving at Select Case for active worksheet syntax. For example

Select Case Worksheet.Activated
Case "Sheet2"
(code goes here)
PrintChecks"
Case "Sheet3"
(code goes here)
End Select

Thanks a lot. mikeburg

[Norman Jones]

Hi Mike,

Try:

Select Case ActiveSheet.Name


---
Regards,
Norman



"mikeburg" <[email protected]> wrote in
message news:[email protected]...
>
> I need help arriving at Select Case for active worksheet syntax. For
> example
>
> Select Case Worksheet.Activated
> Case "Sheet2"
> (code goes here)
> PrintChecks"
> Case "Sheet3"
> (code goes here)
> End Select
>
> Thanks a lot. mikeburg
>
>
> --
> mikeburg
> ------------------------------------------------------------------------
> mikeburg's Profile:
> http://www.excelforum.com/member.php...o&userid=24581
> View this thread: http://www.excelforum.com/showthread...hreadid=474294
>

[mikeburg]

thank you mikeburg