Skipping a tab when with this macro
I am currently using this macro to populate a column with the names of each
tab I have in a workbook. I would like to be able to exclude a tab when this
macro runs. If the tab name is Sheet1, how would I exclude it from showing
up in my column?
For Each ws In Worksheets
i = i + 1
Cells((i + 3), 1) = ws.Name
Next
Thanks for your time!
-Kai
|