Search a range in a sheet

Hi Folks,
My problem is simple. I have a monthly time sheet. The times are entered in cells C8:F68.
When some one has a annual leave day or a bank holiday they enter A/L or B/H.

I have a summary sheet and have placed a cmd button on it to hopefully search the sheets that are months or the year.
I know how to search the sheets and increment through them and not the 'Summary' sheet.

What I need to establish is how to place in my code the actual search criteria and also limit the range to C8:F68
On top of this I need to total each occurance of A/L and B/H and display them in two cells.

I have tried to do a search of the forum but with no luck.
Like I say I have managed to understand how not to select the 'Summary' sheet when incrementing through the sheets but its just the search for the A/L and adding them up!

Cheers for any help.

Tip top !!!
Fantastic, thank you.

Do you know how I could check if a number exists in the same range rather than the text like A/L etc. What I want to do is always make sure that the cell background is white if there is a numeric value in it.

You have guessed I use VB to colour the cell if there is a A/L B/H etc but this does not release if you over type the A/L with a number (time actually).

Cheers again, it worked like a charm.

My code so far is thus but I am having trouble getting the code to loop through each sheet but not the 'Summary' sheet.
I thought I was on the right track but it would seem not.

What I dont want to do is reset the Rng counter as it skips to the next sheet.

Any help would be appreciated.

Cheers

Please Login or Register  to view this content.

This code is not working correctly and I am stuck.
I dont think this is a massive issue but my Cmd button is on the summary sheet and not the monthy sheets.

It only seems to count data if it is in the cell range on the 'Sumary' sheet.
Even then it is counting and adding double the amount ie 2 A/L days it will display as 4 and so on.

Trying hard this end but getting stuck again!!

Cheers again

Have tried is exacty and still doing as I said above!

But why is it counting values from the 'Summary' sheet. That really gets me as we have told it not to!! Most odd I have to say.

JBeaucaire, thanks for your valuble help so far.
Cheers ever so.

Sheet attached.
Interestingly I changed the code from:

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

and it was still counting the values on the 'Summary' sheet where my Cmd button is placed. BUT it was counting correctly rather than doubling up ??

Cheers