Hi Aksel

not sure what you're after here ... let's take another example - cell A1 has
the value 5 (equivalent to your 1002 but a lot smaller) - what do you want
to see on the worksheet?

Cheers
JulieD

"Aksel Børve" wrote in message
...
is it possible to make a macro that use the value in a cell (eg.1002), and
make a Range with same number (1002 cells) of cell's that's diplay in the
one cell.