This post from December has a couple of ways...
http://tinyurl.com/2xksm8
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"M Shafaat"
wrote in message
Hi!
In VBA, how can I check if an array is declaired with a dimension?
Example:
Dim MyArray() As String
No one of the following works:
IsEmpty(MyArray) Then
Not IsNull(MyArray) Then
MyArray Is Nothing Then
Best regards
M Shafaat