VBA: How can I check if an array is declaired with a dimension?
 

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

How can I check if an array is declaired with a dimension?
 

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