Row Reference Using a Random Number

[jackkent]

I would like to be able to generate a random number in a cell and use that number in combination with a column. For example, in cell A1 use a random function to generate an INT(number) from 1 - 10 (no problem). Next I want to use that number in combination with a column letter and instruct Excel to move (goto) that location (cell) on the spreadsheet. I've tried syntax such as goto A&A1 and several other variations but can't get it to work.

Any ideas?

Thanks and regards,

Jack Kent
Chester, NJ 07930

[BigBas]

Jack:

In Excel, you can't go to a cell per se using only Worksheet functions. You can reference a cell (specifically, you can pull the value from a random cell). If you really want to select a cell based on a random number, you have to use VBA. (See sample below):

Post back if you have any questions.

(P.S. I'm from NJ as well, Paramus, 07652. It's nice to see other [somewhat] local members on the board).