Problem with Excel 4 macros (I think)
Chris Wilkinson wrote...
the workbook is very large, so I'm not too sure how I 'm going to
find the named formulas. . . .
Create a new workbook, insert a general module in it, and add the
following macro to it.
Sub foo()
Dim n As Name
For Each n In ActiveWorkbook.Names
If n.Value Like "=*[-+*/^()]*" Then
MsgBox Title:=n.Name & IIf(n.Visible, "", " [hidden]"), _
prompt:=n.Value, Buttons:=vbOKOnly
End If
Next n
End Sub
Then switch to your problem workbook and run this macro. Or download
and install Jan Karel Pieterse's Name Manager add-in.
|