MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sheet count help


Posted by Frank on December 18, 2001 7:27 PM

Hi

Is there anyway to quickly determine how mny visible sheets there are?

like sheets.count will give the total sheet count.

I dont want to set up another loop to calculate this my program is slowwwwww enough as it is, but is there a simple string like visiblesheets.count or something


Thanks


Posted by Juan Pablo G. on December 18, 2001 7:53 PM

Sorry, have to do a loop.

counter = 0
For each sh in Sheets
If sh.Visible then counter = counter + 1
Next sh

This shouldn't take too long tho

Juan Pablo G.