Thread: Navigate Sheets - better way.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug929 Doug929 is offline
external usenet poster
  
Posts: 11
Default 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


Reply With QuoteReply With Quote