Copy formula and change row number in VBA

[Ironchef]

Hi

I want to copy the formula in column "C" to each row, and change the row number each time i add a new row with data. Anyone know how to do this?

I know this won't work, but this is so that you may better understand what I want.

Please Login or Register  to view this content.

[FDibbins]

why would you want to do this through VBA when, if you right the formula correctly, you could probably just have the formula self-adjust itself?

[Norie]

Do you need the formula?

You could just do the calculation in the code and put the result in the cell.

Please Login or Register  to view this content.

[Ironchef]

I've made a userform for the user to type in data that will be added to a database. In one column i want a formula that uses the data from other columns on that row. I can copy the formula down manually, but it wouldn't be very efficient to do that for each record.

So basically, what i need is some kind of way to get the program to understand what row number the current record is on and then create the formula with that rownumber.

[Ironchef]

That would work for that example, but I also need something for the other more advanced formulas.

[Norie]

Just copy the formula from the row above, Excel will automatically change the row numbers just as it does when you copy a formula manually.

Please Login or Register  to view this content.