value to a range

[Aksel Børve]

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.

 

[Bob Phillips]

answer in .programming

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[JulieD]

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