Hi,
Im trying to count the number of non empty cells on a worksheet but there are hidden columns on the sheet. The code im using counts them too how can i count only the "non hidden , non empty cells "
using the following code at the moment:
Nocells = WorksheetFunction.CountA(Sheets("Results").UsedRange)