Steve Belsch
12-12-2019, 10:52 AM
VBA Experts,
I could use some help. I have attached an example document with the code. In the RunMacroAcrossAllTabs() I am doing the following:
- Run a For Each look to skip the first 8 tabs and then run the code on all other tabs. (in this example document I have only have 2 tabs for simplicity and file size, but in the workbook I am using is 146 tabs)
- The code to create subtotals:
1) Copy paste values for columns A through N, K and S through T
2) Run a Do While loop to organize PO# and then calculate a subtotal of each like value
3) Do some formatting
4) Once loop has executed, delete empty rows
Here is my issue. When I made columns M, N and T into values (which I needed to do so that my formulas in Columns A-T could work) it removes the formula in row 266 in those columns and sets it as a 0 value. Is there a VBA code that can go back and make this a calculation? The row will not stay the same, because I have another macro that deletes blank rows. So it will change from row 266 to something different in every tab. But the columns stay the same.
Any thoughts?
Thanks.
Steve
I could use some help. I have attached an example document with the code. In the RunMacroAcrossAllTabs() I am doing the following:
- Run a For Each look to skip the first 8 tabs and then run the code on all other tabs. (in this example document I have only have 2 tabs for simplicity and file size, but in the workbook I am using is 146 tabs)
- The code to create subtotals:
1) Copy paste values for columns A through N, K and S through T
2) Run a Do While loop to organize PO# and then calculate a subtotal of each like value
3) Do some formatting
4) Once loop has executed, delete empty rows
Here is my issue. When I made columns M, N and T into values (which I needed to do so that my formulas in Columns A-T could work) it removes the formula in row 266 in those columns and sets it as a 0 value. Is there a VBA code that can go back and make this a calculation? The row will not stay the same, because I have another macro that deletes blank rows. So it will change from row 266 to something different in every tab. But the columns stay the same.
Any thoughts?
Thanks.
Steve