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:
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
Bookmarks