Thread: Next Worksheet in code
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Next Worksheet in code
Or

ActiveSheet.Next.Select

Be sure that the last sheet is not active when you run the code


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Smallweed" wrote in message ...
Worksheets(ActiveSheet.Index+1).Activate

"Gary S" wrote:

Basic vba question.

How do I go to the next worksheet using code?
--
Thanks for your help!
Gary S
Reply With QuoteReply With Quote