cell adressing

[surffrank]

I would like to select each time different cell in same column using random
number. I generate the number but don't know how to implement it in the cell
address?

[bpeltzer]

If you want to choose from column A, in the row range of 1-10: =INDIRECT("A"
& INT(RAND()*10)+1). The '1' in the formula indicates the minumun row that
can be selected; the '10' indicates the number of rows among which to select
(so 10 rows from column A, starting at row 1 is the range A1:A10).

"surffrank" wrote:

> I would like to select each time different cell in same column using random
> number. I generate the number but don't know how to implement it in the cell
> address?

[Mort_Komabt]

Use the following

Range("a" & ref).Select

where ref is your random number and "a" is your coloum reference

"surffrank" wrote:

> I would like to select each time different cell in same column using random
> number. I generate the number but don't know how to implement it in the cell
> address?

[surffrank]

Perfect, thanks a lot


"bpeltzer" wrote:

> If you want to choose from column A, in the row range of 1-10: =INDIRECT("A"
> & INT(RAND()*10)+1). The '1' in the formula indicates the minumun row that
> can be selected; the '10' indicates the number of rows among which to select
> (so 10 rows from column A, starting at row 1 is the range A1:A10).
>
> "surffrank" wrote:
>
> > I would like to select each time different cell in same column using random
> > number. I generate the number but don't know how to implement it in the cell
> > address?