Thread: Referring to a Worksheet with a variable
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
  
Posts: 3,986
Default Referring to a Worksheet with a variable
Sheets("MySheet")

"donbowyer" wrote:

This The expression works OK:-
Set VBComp = ThisWorkbook.VBProject.VBComponents("Sheet1")
But what is the correct syntax if I want to refer to a sheet with a variable
number?
Suppose the variable sheet number is MySh, then ("SheetMySh") produces a
runtime error "Script out of range"
--
donwb
Reply With QuoteReply With Quote