Hi,

ps, save your Workbook before you play with Macros, and as a different
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 where
you wish this to happen, amend the columns H & B to be where you want
the formula to show (a spare column) and where the formula was.
Run the macro.

Hope this helps

Change formulas to values Wrote:


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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=401367