Formula help!

N

nic17

Hi,

I am just trying to write a formula that counts the number of non-blan
cells in a column.

E.g. In column G, i know there are 166 populated cells, but this coul
change. So how can a formula calculate this authomatically?

Any ideas
 
K

kvenku

hi
you can try this out.

dim i
for i = 1 to columns.count
if len(cells(7,i).value) > 0 then
count=count+1
end if
next

where count is the count of the populated cells

I beleive this is what you want

Thanks
venkatesh
 
Top