VBA function to count rows with a value

[didge]

All

My spreadsheet has about 12 columns of data that is entered by hand. Each row of data is values given by a participant in a course for a particular element of the course (such as Overview, Handouts, etc). A participant may not attend a particular section of a course - thus those cells will be empty. I want to be able to count to number of scores entered and ignore the blank cells. I'm doing this through VBA as it feeds into a larger calculation for averages.

I have figured out how to find the last cell in a row:

Please Login or Register  to view this content.

But I can't seem to figure out how to count only the cells in the row that have a value.

I have looked in the forums - but am not sure what I should be looking for.

Thanks
Didge.

[rylo]

Hi

If you only want to count numeric entries in a range, then use

Please Login or Register  to view this content.

If that doesn't help, then provide more details of your structure, and what you want to count from where, and why.

Perhaps attach an example workbook to clarify.

rylo