Exel2000/2003 create range from ...

[kaul1jos]

I have a range from 1 to 300.

From the range I would like to create new random ranges with a max of 40. There must also be more new range so all numbers of the first range are used.

What formula do I need for a solution?

thnx in advance for your help

 

[SkipVought]

Hi,

Check our Dynamic Range Names using the OFFSET function

How can I rename a table as it changes size faq68-1331

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}