Thread: Why does this code not work?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rk0909 rk0909 is offline
external usenet poster
  
Posts: 50
Default Why does this code not work?
All,

I am trying to use the code name of sheets instead of the tab name, but it
wouldn't work for me. Any help will be appreciated.

Thanks much,

RK

Sub test()
Dim n As Integer

n = 1
wks = "sheet" & n

wks.Select
End Sub

Reply With QuoteReply With Quote