Excel - counting values

[Chattin]

How do I count the number of values in a range of cells with VBA - what I want to do is create a chart if there are, for example, 10 values in the 10 cells in the range but not if there isn't. Hope that makes sense. Thanks in advance.

 

[xlbo]

myTestCount = worksheetfunction.count(sheets("Sheetname&quot.range("A1:A10&quot)

should do the trick for you Rgds
~Geoff~

 

[Chattin]

Thanks for that! I'll give it a go

 

[aMember]

COUNT gives you the number of cells in a range. It seems you want the number of values in a range. If that is the case, COUNTA might work for you

myTestCount = worksheetfunction.COUNTA(sheets("Sheetname&quot.range("A1:A10&quot)

It counts the number of non-blank cells so if only 5 cells contain data, it will return 5.

 

[xlbo]

Actually, COUNT, will count all NON BLANK cells
COUNTA will count all cells with a numerical value in

For this instance, I believe either will do Rgds
~Geoff~