Thread: Selecting a worksheet based on the sheet Number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Selecting a worksheet based on the sheet Number
Your code is good. Does Sheet40 exist???
--
Gary''s Student - gsnu200819


"QuietMan" wrote:

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