Convert to Values
I have a workbook that has 40 tabs. In each of the tabs there are formulas
referenced to a tab named €śDBASE€ť , which is one among the 40 tabs.
Is it possible to convert only those €śDBASE€ť reference formulas wherever
referenced in all the 39 tabs into values by a single action using a macro.
All the tabs have data from Range A2 to AG4000
|