Thread: Empty Array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Empty Array

Hi
Could be wrong here, but would you not do

Public ObjCollArray() as string

and then inside the sub

Redim ObjCollArray(0 to 6)

regards
Paul