Want to copy a cell x times

drag-driver · Feb 19th, 2002, 09:41 AM

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 · Feb 19th, 2002, 09:42 AM

From my post at

http://www.mrexcel.com/board/viewtop...=175&forum=2&1

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

Code:

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 ]

Feb 19th, 2002, 09:42 AM	#2
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	From my post at http://www.mrexcel.com/board/viewtop...=175&forum=2&1 The complete code, which you can just copy and paste, would be something like: Code: 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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 09:41 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	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.