View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bloycee bloycee is offline
external usenet poster
 
Posts: 3
Default Named Range to Array Oddity

I've just used a named range to fill an array and have found a
peculiarity that I'm not sure about. The named range was not
contiguous and when assigning it to the array the array only appears to
have used the second section of the range. Is this what normally
happens and is there a work around?

If I gave each part of the original range a separate name could I then
read them easily in to the same array? How?