is there a way to change formulas to values for sorting purposes?

B

Bryan Hessey

Hi,

ps, save your Workbook before you play with Macros, and as a differen
name afterwards.

To change the H column to reflect the formula in column B is

For i = 1 To 100
Range("H" & i).Value = "'" & Range("b" & i).Formula
Next i

To put that into a macro, select Tools, Macro, Record new macro,
select a cell, then end the macro recorder.
then, Tools, Macro, Macros, select the macro and Edit.

Copy the code, and amend the For i = 1 to 100 to show the rows wher
you wish this to happen, amend the columns H & B to be where you wan
the formula to show (a spare column) and where the formula was.
Run the macro.

Hope this helps

is there a way to change formulas to values for sorting purposes
 
Top