View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger Roger is offline
external usenet poster
 
Posts: 226
Default Go to first empty worksheet in a certain group of sheets

Hello All,

I have a group of 10 worksheets hidden in a Workbook. Im looking for a
Macro to find the first empty sheet in that 10 page hidden group. Each sheet
in the group is named T with a number next to the T (i.e. T1, T2,T3,
T4.etc).

The criteria for the page being empty is based on cell A1 being empty.

Any thoughts would be greatly appreciated.

Thank you Roger