Copy Formula down x Number of rows

's Computer Specifications

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

's Computer Specifications

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

<(E-Mail Removed)> wrote in message
news:a1e4d5fa-ce43-4635-8d7c-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy down with variable number of rows	mohavv	Microsoft Excel Misc	5	15th Nov 2007 04:18 PM
Copy a selected number of rows	=?Utf-8?B?RXJpYyBTLg==?=	Microsoft Excel Misc	4	25th Jun 2007 08:23 AM
want to copy formula, only change one number in formula	=?Utf-8?B?Y2FjMTk2Ng==?=	Microsoft Excel Worksheet Functions	3	12th Mar 2007 10:39 PM
COPY FORMULA EVERY TWO ROWS	=?Utf-8?B?YW5kcmVzZzE5NzU=?=	Microsoft Excel Misc	1	6th Oct 2006 05:29 AM
Re: Copy Formula loop based on number of rows w/ data in a col B.	Bernie Deitrick	Microsoft Excel Programming	1	20th Aug 2004 10:17 PM