Good morning all,

I am trying to write a macro that loops through all the sheets in an active workbook and looks for formulas starting with GXL [i.e. =GXL() or =-GXL()] and replaces the formula with the value for that cell. My current macro doesn't work so I am trying to build it from scratch and hoping someone has done this in the past.