VBA CountA method

CountA function returns counts of cells that are not empty (in range or array).

Alternatively, CountA returns the count of cell in range or array with data.