View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default 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