Count occupied cells

I need a macros to count the number of occupied cells (not including row 1 column 1) and then populate a cell (in column f) indicating the value it counted

thanks!

Backup your data.
Place the code below into a standard module.
The answer is placed below the last data in column F.
It does not count cells in row 1 or in column A.

Please Login or Register  to view this content.