Thread: Selecting a worksheet based on the sheet Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Quietman Quietman is offline
external usenet poster
  
Posts: 109
Default Selecting a worksheet based on the sheet Number
Can anyone tell me why the code does not work

TTK = 40
Sht_Select = "Sheet" & TTK
Sheets(Sht_Select).Select

Thanks

--
Helping Is always a good thing
Reply With QuoteReply With Quote