Copy Formula down x Number of rows

S

stvn.taylor

Hello,

I would appreciate some help with the following.

I am looking for some VBA code that will copy the formula
in a selected cell and then paste the formula down x number
of rows.

Thanks,

Steve
 
R

Rick Rothstein \(MVP - VB\)

Try this code where I am copying the contents of B4 on Sheet1 down 10 more
cells below it.

NumberOfCopies = 10
With Worksheets("Sheet1").Range("B4")
.Copy .Offset(1).Resize(NumberOfCopies, 1)
End With

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy rows in range if data in first cell 7
Copy Formula Down until last row 2
Fill Down based on count in another sheet 2
Copy formula down variable rows based on (lastrow) from another sh 3
vba entering a formula in a certain cell 2
Copy rows and insert (x) number of times 4
Text To Columns then insert rows 9
Delete rows based on contents of Col A 0

Top