Read a Range into an Array
Hi everyone,
In a Worksheet named "Input" and in Cells "B3:G?" I have 6 number
groups. How can I ...
( 1 ) Put each of the 6 number groups into an array when I don't know
what the last row number is.
( 2 ) Find the maximum value in any of those cells and attach it to a
variable named MaxVal.
.... so once I have done this I can then loop through each 6 number
group and perform some calculations.
Thanks in Advance.
All the Best.
Paul
|