Thanks for getting back to me. ...

You're welcome.

Regrets. I'm out of further suggestions for you here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AJ" wrote in message
...
I meant B2:K2 (not B1:K1 as previously stated)

"AJ" wrote:

Hi,

Thanks for getting back to me.

It's a good answer, but not quite what I'm looking for.

I'll explain exactly what I'm doing:

I'm studying Japanese and I'm wanting to create a spreadsheet which
randomly
selects a number of images from the alphabet and then I'll test to see if
I
can read them.

Let's say I copy and paste 45 images of Japanese symbols on to Sheet 2.

on sheet 1, cells A1:K1 contain a formula which shows random whole
numbers
between 1 and 45 (these values change each time I press F9/re-calculate
the
sheet)

on sheet 1, cells B1:K1 contain a formula which results in an image
depending on what value is shown in the cell above it.

So, whenever I press F9/recalculate the sheet, new images are instantly
placed in cells B1:K1 for me to try and read.

Hope that makes sense.

Thanks again,

AJ