ExcelLearner25
New Member
- Joined
- Jan 20, 2023
- Messages
- 8
- Office Version
- 2016
- Platform
- Windows
I have a big spreadsheet that needs lots of processing to fix problems introduced from a conversion. I've been using VBA to mimic how I would do it manually: insert blank columns, put a formula in each column to modify the old data, then hide or delete the original column, leaving the new columns with the modified data (I convert it to values too when it's done).
But adding all these columns and formulas with code seems like an inefficient way of doing this. Is there a better way, such as by having VBA that directly modifies the original columns of values?
But adding all these columns and formulas with code seems like an inefficient way of doing this. Is there a better way, such as by having VBA that directly modifies the original columns of values?