Why do you want to Check?

Seems like you should know.

If it is a global variable that you are checking if it is populated then how
have you declared it?

If you used

Public v as Variant

then isarray(v) should work

If
Public v() as Whatever

then you have received answers for that.

--
Regards,
Tom Ogilvy


"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