Hi,

I simply have an array loaded with strings only. If I use
Ubound and there are empty elements in the array, will the
Ubound pick up the empties too. I do not want to count
the empties.

n = Application.WorksheetFunction.CountA(YourArray)

Regards,

Daniel M.