Easy Autofill

Jose Miguel

Board Regular
Joined
Feb 3, 2005
Messages
99
Hello,

I'm creating a macro that will insert column and total, but also in that inserted column I need to have a formula. The formula in H2(b2+f2), I need autofilled to the bottom of the column. The size of this column will change all the time, so I need a macro to take this into account. Please help!

Jose
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Try something like:

Code:
Range("H1:H" & Range("A65536").End(xlUp).Row).FillDown
 

Watch MrExcel Video

Forum statistics

Threads
1,118,817
Messages
5,574,499
Members
412,598
Latest member
Haven1234
Top