how to multiple the rows by a given number

[xianwinwin]

Hi guys,

I wonder if anyone can assist me on this one: say I have the word Apple on cell A1 and the number 60 on cell A2, question is how can I have the word apple multiply 60 times between A1 to A60?

Is there such possibility? (Without dragging the cursor to A60)

[I have 500 addresses and I need to multiply each by either 60 or 50)

Thanks for any help

[RJ]

Well the only way I know to do this is through a loop in VBA. If the word you
wanted repeated was in cell A1 and the number of times you wanted it repeated
was in cell B1, then the following code when ran would paste the word in cell
A1 down the number of times of cell B1.

Sub mutliplerows()
X = Cells(1, 2).Value
i = 2
Do Until i = X + 1
Cells(i, 1).Value = Cells(1, 1).Value
i = i + 1
Loop
End Sub

"xianwinwin" wrote:

>
> Hi guys,
>
> I wonder if anyone can assist me on this one: say I have the word Apple
> on cell A1 and the number 60 on cell A2, question is how can I have the
> word apple multiply 60 times between A1 to A60?
>
> Is there such possibility? (Without dragging the cursor to A60)
>
> [I have 500 addresses and I need to multiply each by either 60 or 50)
>
> Thanks for any help
>
>
> --
> xianwinwin
> ------------------------------------------------------------------------
> xianwinwin's Profile: http://www.excelforum.com/member.php...o&userid=35264
> View this thread: http://www.excelforum.com/showthread...hreadid=550353
>
>

[xianwinwin]

thanks, I got familiar with macros :-)