Help Inserting formulas into cells

[gammaman]

I have a vba macro in which I am appending columns to an already existing excel data sheet. I append these additional Columns as follows.

NOTE: I have intentionally changed the Column Names.

Please Login or Register  to view this content.

The above code works great. However, now in Row A2, I want to insert Formulas into each of those new columns. I am trying to do the following but it does not insert anything.

Please Login or Register  to view this content.

[ragulduy]

There is nothing wrong with the way you are inserting the formula, I do note a couple of things though:
-The last term in your fcalc array does not have double "'s and will return an error
-it doesn't look like it will pick up the same columns as your first macro, maybe it is putting the formulas in a different cell to where you are expecting? Why do you have the -7 for the count? you will pick up the last column, then place it into the 7th column before, 8th column before, 9th column before etc?

It might be a good idea to post all of your code not just the snippet.