acharsanthosh
New Member
- Joined
- Dec 20, 2017
- Messages
- 9
Hello Folks,
I have a workbook with 45 sheets and all the sheet names listed in 45th Tab naming "Other Data".
Now I want to run a for each loop based on the sheet list name range in "Other Data Tab".
Can anyone please help me out with this?
Am able to run the loop for all the worksheets as below
Sub loopforeach
Dim ws as Worksheet
For Each ws in Worksheets
Next
End Sub
Looking forward for your help!!
Thank you
San
I have a workbook with 45 sheets and all the sheet names listed in 45th Tab naming "Other Data".
Now I want to run a for each loop based on the sheet list name range in "Other Data Tab".
Can anyone please help me out with this?
Am able to run the loop for all the worksheets as below
Sub loopforeach
Dim ws as Worksheet
For Each ws in Worksheets
Next
End Sub
Looking forward for your help!!
Thank you
San