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

Arrays - Horizontal or Vertical
 

What is the code you are using and how do they input a range


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=490733

Arrays - Horizontal or Vertical
 

It's ok I figured it out.

"tony h" wrote:


What is the code you are using and how do they input a range


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=490733