Keith,

What do you mean by "Select"? Do you want a macro that selects cells, a function that does something
to that number of cells, or something else entirely?

HTH,
Bernie
MS Excel MVP


"bollard" wrote in message
...
I have a spreadsheet where, in one column there is a number. The next column
holds a list of random numbers. I want the sheet to look at the number in the
first column and then select that number of entries from the random number
column to use.

e.g. if the number in the first colum is 5, it will select the first 5
random numbers from the next column.

Can anyone help, please?

Keith