Excel 2010 - Tables and Overwriting Calculated Columns

[ajay_gajree]

Hi All

When you put a formula in a column in a Table this will copy to all cells in that same column.
If you then overtype this (In a table with 2 or more rows), a smart tag appears asking if you wish to

"Restore to calculated column formula"

I want to access this using VBA, so I can correct any cells that are mistakenly overwritten with the correct formula.

Tried searching the excel object model, tried recording a macro (Nothing records), and tried good old google!

I have found that the keyboard short cut for this is Alt + Shift + F10 then R.

Even when I record these nothing gets recorded!

Any help appreciated!

 

[RoryA]

I don't think there is any direct access to that. I suspect you'd have to loop through the cells in the column until you found one where cell.Errors(InconsistentTableFormula).Value was False, and you could then apply that cell's Formula property to the whole column.