VB: default cell formula

[rnation]

Is there a way to assign column cells a formula that references other cells in VB. I have gotten around this by running a macro that copies the previous cell formula from above and pasting it on line below. that method has flaws that I can no longer use.

The idea is to make cell C2 = B2*A2... and C3 = B3*A3, but having VB assign the formulas. Row 1 is all column titles so VB would have to omit row 1 from the formula as well.

Help!

 

[Joe4]

If I understand you correctly (and I am not sure that I do), I think the following should work for you.

Let's say that you wanted to populate C2 through C10 with a formula that multiples column A in that same row by column B. This simple one-line VBA code would do that:
Range("C2:C10").FormulaR1C1 = "=RC[-2]*RC[-1]"

Is that what you are looking for?

 

[rnation]

If I understand you correctly (and I am not sure that I do), I think the following should work for you.

Let's say that you wanted to populate C2 through C10 with a formula that multiples column A in that same row by column B. This simple one-line VBA code would do that:
Range("C2:C10").FormulaR1C1 = "=RC[-2]*RC[-1]"

Is that what you are looking for?

The formula will be more difficult than that, but yes. The idea is to write a formula to lookup the description (from another spreadsheet) of a product by using the product# in column C. Over time some products may get added or may be discontinued, so there will be new numbers that are referenced or product numbers that have been taken out. So if the Product# is in Column C of the reference spreadsheet then that Description should be used, otherwise if the product# is no longer used then lookup existing description.

I hope this helps clarify, but I am not sure it does.

 

[Joe4]

Instead of trying to simplify it, why not tell us exactly what you want, complete with data examples? The more details you provide, the better the solution will probably be.