Navigate Sheets - better way.
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" wrote in message
...
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
|