Then as Tushar says, for a dynamic array, you need to trap it, so I think
you have the best way.

Regards

Bob


"VBA Dabbler" wrote in message
...
Just checking for a better way.

"Bob Phillips" wrote:

That works. Do you have a problem with it, or just checking if there is
another way.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"VBA Dabbler" wrote in message
...
Does anyone know how to proactively test an array for data prior to
its
use
without using an error event?

If not, what is a good error test?

I have been using 'Err.Number = 9' as a test to call the population
routine.

Thanks,
VBA Dabbler