I am trying to create a simple count macro that will return the count to an embedded label on Sheet1.

The count is essentially all Items (i.e cell that maintains a value) in column A of Sheet2 starting at Row8

If there is none then count = 0

I plan on incorporating this into my workbook open code.

thanks for any help in advance.