View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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.