View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fullers80
 
Posts: n/a
Default Arrays - Horizontal or Vertical

I am writing a function that asks the user to input a range.

At the moment I have it set up so that the range has to be in a row. The
formula then goes off and does something with the values one by one along the
array until it reaches the last one.

Is there a code I could put in so that it would not matter whether the user
made the array horizontal or vertical?

Thanks