Is there some way to render the macro/formula results in a worksheet/cell permanent. For example if you using macros to extrapolate resulting information like extracting first and last name from one cell into two cells, then is there a way to freeze the resulting data so the formula is no longer there.
Problem is arrising when I send the ws to someone else and they open the ws on their machine and the data gets distorted i.e the last name column is a list of &'s.
Ideally would like to leave row and column data resulting from macro operations in-tact and then remove all formulas or turn them off or something so that all is left is the data with no formulas.
Is this far fetched?
Bookmarks