looping through specific sheets in workbook

Here is a tricky one.
I have about 30 sheets in my workbook,the sheets have different names.
One set of sheets(6 in all) are entitled data1 data2 data3 through to data6.
what the code does is count the number of rows in each sheet containing data then puts the result into another cell in a seperate sheet(Sheet 11 in this example).
So far I have used the following code to do this:

Please Login or Register  to view this content.

This works OK but it stops if one (or more)of the data sheets has no data in which can some times happen.
So I have two questions.
A)Is there a way I could put this into a loop bearing in mind that the 6 sheets are only part of a workbook with lots of other sheets in,so I would only want to loop through those 6 sheets and not the entire workbook.
B)secondly is there a way that when one or more of the data sheets(in the six sheets) had no data then it just goes on to the next sheet.
I have had a go but I am not that good with loops
Any suggestion are always welcome
Kind regards
bif

How about

Please Login or Register  to view this content.

Hi Fluff13

Thankyou for the quick reply the code works perfect and I have managed to adapt it for other bits of the program as well.It's also put loops and arrays into a bit more perspective for me.Again many thanks

Kind regards
BIF

Glad to help & thanks for the feedback