Hi Peter,

My appologies. Unfortunately I am unsure how to, or indeed if it can
be done, to incorporate your suggestion into the actual task I am
trying to achieve.

Thanks in Advance.
All the Best.
Paul

On Aug 10, 9:10 pm, "Peter T" <peter_t@discussions wrote:
If the suggestion I gave in reply to your previous and virtually identical
question didn't help, explain why not and more detail of what you want to
do.

See thread -
Find Last Cell in Range, 8-Aug-07

Regards,
Peter T

"Paul Black" wrote in message

ups.com...



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- Hide quoted text -

- Show quoted text -