Excel forgets Custom VBA Function (#Name error)
It might be quicker to just
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all
Record a macro when you do it if you really need a macro solution.
R Avery wrote:
CalculateFull is not an option for me because this spreadsheet is so
large that it would be a disaster if it tried to recalc itself...
I have found a solution to my problem. I bound to SHIFT-CTRL-F the
following sub:
Public Sub FixFormulas()
Dim r As Excel.Range
For Each r In ActiveWindow.RangeSelection.Cells
r.Formula = r.Formula
Next
End Sub
--
Dave Peterson
|