View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M Shafaat M Shafaat is offline
external usenet poster
 
Posts: 2
Default 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