View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kai Cunningham[_2_] Kai Cunningham[_2_] is offline
external usenet poster
 
Posts: 13
Default 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