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