ajay_gajree
Well-known Member
- Joined
- Jul 16, 2011
- Messages
- 518
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!
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!