Want to copy a cell x times

[drag-driver]

Want to copy a cell which contains a formulae down a colume a certain no. of times x.Do not have knoledge of VB. A cell formulae or no. of steps i could record would work or how to aply the previous VB soltion would help my situation.

 

[Barrie Davidson]

From my post at

http://www.mrexcel.com/board/viewtopic.php?topic=175&forum=2&1

The complete code, which you can just copy and paste, would be something like:

Sub Copying()
Dim i As Integer
i = 12
Range("A1").Copy Destination:=Range("B1").Range("A1:A" & i)
End Sub

Does this help you?


_________________

Barrie Davidson
My Excel Web Page
This message was edited by Barrie Davidson on 2002-02-19 08:44