count words before empty row

[makinmomb]

Look at what i have written on B1 and b19 manually done

Want macro to do that

There will be more empty rows below , this i have trimmed for sample

LOGIC count words at every new row

[KOKOSEK]

Something like this:

Please Login or Register  to view this content.

[mohadin]

Hi
Try

Please Login or Register  to view this content.

[HansDouwe]

Or with a formula:

Insert a row at the top and try in C2 (or B2) and copy down:

Please Login or Register  to view this content.

[pjwhitfield]

And a slightly different version of the VBA one

Please Login or Register  to view this content.

[makinmomb]

Thank you all codes working as required