redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,604
- Office Version
- 365
- Platform
- Windows
Hi all
I'm using this line of code to activate a workbook sheet
So the 'value' found in cell ref A1 of the Front sheet will always be a number between 1 and 31
The workbook contains 31 sheets, named 1,2,3,4,5, etc etc thru to 31
I want the code above to activate the sheet name with the same value found in A1
For example if A1 holds the number 6 , I would like the sheet that is also called '6' to be activated, NOT SHEET6, as sheet6 may actually be called '16'
hope this makes sense and appreciate any help
Kind regards
I'm using this line of code to activate a workbook sheet
Code:
Worksheets(Worksheets("Front").Range("A1").Value).Activate
So the 'value' found in cell ref A1 of the Front sheet will always be a number between 1 and 31
The workbook contains 31 sheets, named 1,2,3,4,5, etc etc thru to 31
I want the code above to activate the sheet name with the same value found in A1
For example if A1 holds the number 6 , I would like the sheet that is also called '6' to be activated, NOT SHEET6, as sheet6 may actually be called '16'
hope this makes sense and appreciate any help
Kind regards