captainxcel
New Member
- Joined
- Jul 28, 2017
- Messages
- 35
- Office Version
- 2016
- Platform
- Windows
Hi,
I run a loop macro to increase the number of rows in 25+ client tables when a new ticker symbol is added. Unfortunately, some columns in each table have gone through iterations of formulas and the new cells in those columns are populating with old formulas when new row(s) are added. The manual fix for this is to F2 in the topmost cell in each table column where this is an issue, copy the formula, escape, select the whole column, clear the contents of all cells in that table column, then f2 back into the cell, paste the formula, end hit enter. Would there be a VBA solution to this as I am going through about 5 columns in each table.
Thanks!
I run a loop macro to increase the number of rows in 25+ client tables when a new ticker symbol is added. Unfortunately, some columns in each table have gone through iterations of formulas and the new cells in those columns are populating with old formulas when new row(s) are added. The manual fix for this is to F2 in the topmost cell in each table column where this is an issue, copy the formula, escape, select the whole column, clear the contents of all cells in that table column, then f2 back into the cell, paste the formula, end hit enter. Would there be a VBA solution to this as I am going through about 5 columns in each table.
Thanks!