Navigate Sheets - better way.

I want to navigate from one sheet to the other. Is there a better way then
this....

' Go back and format previous sheet.
Sheets(Worksheets.Count - 1).Select
' Format sheet.
Call SB2_Format
' Come back and start again.
Sheets(Worksheets.Count).Select

activesheet.previous.select
SB2_Format
ActiveSheet.Next.Select

Not sure if it makes any difference.

Another approach would be to modify SB2_format so you can pass a sheet
reference to it and it can format that sheet without activating it.
then the code could just be

set sh = Activesheet.Prevous
SB2_Format sh
--
Regards,
Tom Ogilvy

"Doug929" <[email protected]> wrote in message
news:[email protected]...
> I want to navigate from one sheet to the other. Is there a better way then
> this....
>
> ' Go back and format previous sheet.
> Sheets(Worksheets.Count - 1).Select
> ' Format sheet.
> Call SB2_Format
> ' Come back and start again.
> Sheets(Worksheets.Count).Select
>
>

Thanks Tom, you have been helping for years! I appreciate it.

"Tom Ogilvy" wrote:

> activesheet.previous.select
> SB2_Format
> ActiveSheet.Next.Select
>
> Not sure if it makes any difference.
>
> Another approach would be to modify SB2_format so you can pass a sheet
> reference to it and it can format that sheet without activating it.
> then the code could just be
>
> set sh = Activesheet.Prevous
> SB2_Format sh
> --
> Regards,
> Tom Ogilvy
>
> "Doug929" <[email protected]> wrote in message
> news:[email protected]...
> > I want to navigate from one sheet to the other. Is there a better way then
> > this....
> >
> > ' Go back and format previous sheet.
> > Sheets(Worksheets.Count - 1).Select
> > ' Format sheet.
> > Call SB2_Format
> > ' Come back and start again.
> > Sheets(Worksheets.Count).Select
> >
> >
>
>
>