Unwanted change of formulas in a table

[ArnolddG]

Hi,
I am copying formulas in a table in the same column via VBA.
How do I prevent the formulas automatically being copied in ALL of the cells of the column?

Example:

Please Login or Register  to view this content.

After running this in a sub all cells in column B of the table have the same formula "=4+4"
How do I prevent that ?

[Ron Coderre]

There are a few methods on this website you might want to employ to prevent table formulas from auto-populating:
http://office.microsoft.com/en-us/ex...#_Toc295810735

Is that something you can work with?

[nathansav]

Are you sure? I dont get that???? Ignore me, i wasnt trying it on a table.

[ArnolddG]

Thanks Ron,
That setting works okay, but it seems to be an Excel setting rather than a workbook setting.
That means that when I distribute my workbook, I have to make sure users change that setting too.
Would there possibly be a way to have the same result on a workbook level, of (even better) on a table level ?

[Ron Coderre]

Well...maybe a "stupid Excel trick"?
Try this:

Please Login or Register  to view this content.

That code prevents Excel from detecting a formula pattern.

Is that something you can work with?

[ArnolddG]

That seems to be the trick!
First take the values out of an order and then fill the cell with formulas.
Thanks !