Thank you Alan and Frank. God bless.

"Alan Beban" wrote:

Frank Kabel wrote:
Hi
have a look at UBound in the VBA help


More specifically, since it might not be apparent from the On-line help:

UBound(myArray) - LBound(myArray) + 1

Alan Beban