Thread
:
Selecting a specific sheet by codename in an opened workbook (XL03
View Single Post
#
2
Posted to microsoft.public.excel.programming
John Bundy
external usenet poster
Posts: 772
Selecting a specific sheet by codename in an opened workbook (XL03
Try setting the sheet name as a string and then call it like this
mysheet = "Sheet3"
Sheets(mysheet).Select
Reply With Quote
John Bundy
View Public Profile
Find all posts by John Bundy