View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kdw kdw is offline
external usenet poster
 
Posts: 13
Default Checking existence of array dimensions

Is there any way to check for how many dimensions an array have? For
example, I can use ubound(TempArray,1), ubound(TempArray,2), etc. But what
if there is no 2nd dimension. My code would fail. I would not want to loop
through the column dimension if there isn't any so I need some way to check
for it.

Many thanks.