AutoFill Formulas Easy one

brettvba · Apr 8th, 2002, 03:08 PM

In my code I have
Selection.AutoFill Destination:=Range("E2:G1029")
can I change that so it fills down to however many rows I have whether it be 1029 or 65000,
because my data changes all the time?
I can't think today.

Jay Petrulis · Apr 8th, 2002, 03:18 PM

Quote:

On 2002-04-08 14:08, brettvba wrote:
In my code I have
Selection.AutoFill Destination:=Range("E2:G1029")
can I change that so it fills down to however many rows I have whether it be 1029 or 65000,
because my data changes all the time?
I can't think today.

Hi,

Try,

lastrow = Cells(Rows.Count, "D").End(xlUp).Row

Selection.AutoFill Destination:=Range("E2:G" & lastrow)

Untested, but should work.

Bye,
Jay

brettvba · Apr 8th, 2002, 03:45 PM

Yeah that works great thanks

First Wob · Apr 9th, 2002, 07:15 PM

Thanks Jay. I had a similar question but all the answers I found seemed too complicated for this rookie. Spent 1 1/2 hours trying to apply them. Took 5 minutes on this and it works great!

[ This Message was edited by: First Wob on 2002-04-09 18:16 ]

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

Apr 8th, 2002, 03:08 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	In my code I have Selection.AutoFill Destination:=Range("E2:G1029") can I change that so it fills down to however many rows I have whether it be 1029 or 65000, because my data changes all the time? I can't think today.

Apr 8th, 2002, 03:45 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Yeah that works great thanks

Apr 9th, 2002, 07:15 PM	#4
First Wob New Member Join Date: Apr 2002 Location: Centerville, Indiana Posts: 14	Thanks Jay. I had a similar question but all the answers I found seemed too complicated for this rookie. Spent 1 1/2 hours trying to apply them. Took 5 minutes on this and it works great! [ This Message was edited by: First Wob on 2002-04-09 18:16 ]