AutoFill Explanation

Question

I know this questions been asked tons of times but I've attempted to use solutions from other answers and haven't been able to get it to work for my excel macro.

I have;

Range("G2").Select

Selection.AutoFill Destination:=Range("G2:G870")

However, G870 will not always be the final cell of the ending part of the range. I was hoping so it automatically picks up on whatever the range is based on the final data entry in column F. I'm not sure how to code this.

Thanks

score 4 · Accepted Answer · answered Aug 03 '20 at 18:58

4

Just find the last row:

Range("G2").AutoFill Destination:=Range("G2:G" & Cells(Rows.Count, "F").End(xlUp).Row)

answered Aug 03 '20 at 18:58

BigBen

46,229
7
24
40

Where do I add this into the code? Do I replace the 2nd line in my post or both? – LittleAuditorium Aug 03 '20 at 19:03
1

You replace both lines. `Range("G2").Select` is unnecessary, see [this](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba). – BigBen Aug 03 '20 at 19:03
Hey Ben, if I wanted to do this same mechanic but auto fill columns G to J. What would I swap in the code? – LittleAuditorium Sep 28 '20 at 17:58
`Range("G2:J2")` and `Range("G2:J"....` probably @LittleAuditorium. – BigBen Sep 28 '20 at 18:12

AutoFill Explanation

1 Answers1

Related