copying cells a set no. of times

Guest · Feb 19, 2002

Want to copy a cell which contains a formulae down a colume a certain no. of times x.

Barrie Davidson · Feb 19, 2002

On 2002-02-19 07:40, Anonymous wrote:
Want to copy a cell which contains a formulae down a colume a certain no. of times x.

I assume you want to do this in VBA. The following code will copy the formula in cell A1 to twelve rows in column B starting at column B1.

Code:

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

Just make changes as required.