Dynamic range with count ?

[vumian]

Dear all,

I have a row, contains numbers,

i want to count how many number on that row, Result must be dynamic 'cos i offten add/delete them

Thanks in advance,

[ratcat]

G'day,

Use the count function.

But were are you placing the formula, is it on the same row of the deletion ?

[vumian]

I place the function below 1 row which row i want to count ?

[ratcat]

G'day again,


Say you want to count row 4

Please Login or Register  to view this content.

Edit: I've add attachment after some though. It a macro will insert a count formula and count the row above the edit box

Eg To count row 4, place the edit box in the row 5 (it doesn't matter where). Press the macro button. The count for row 4 is done.
To count row 1 place edit box in row 2. To count row 102 place edit box in row 103.

Hope that helps