Counting the number of occurances in a single row

hi,

I am writing a vba program in excel and i have come across a situation where i need some help.

I have a row of column headers. This row has lots of information in it. There are "quizes" that have column labels of E1, E2, E3....En. What i want to do is somehow count the number of quizes (or E#'s) that may be in this row. Anyone have any ideas on how to do this.

Yes, i need a macro to do this.........i am writing a program and this is something ineed to do within the program.

thanks...this almost works.

The problem is i only want to count entries like the following:
E1, E2, E3, ......En


I dont want to count things like
E1-1, E2-1.....etc

Hi,

Building on Richard's code, with your new requirement :

Please Login or Register  to view this content.

HTH

Or using Richards' code

Please Login or Register  to view this content.

Change "=E*" to "=E?"

thanks! i think i can make one of these work.

i just noticed that if i have E10 or above like E11, E12, E13........this method does not count those. Any suggestions?

i modified the code to handle up to 3 characters.....but i was wondering if there was a better way

Please Login or Register  to view this content.

Hi,

From what you said so far, you need a pattern based on all your potential cases...
Have a try with : ="E*?"

HTH