Searching for text within formula
Isabelle,
OK, it figures that as soon as I declare something working ... it
stops working.
When I run the macro, I get the following error:
Run-time error '1004'
Application-defined or object defined error
When I click on the Debug button, the Visual Basic editor
highlights the following line:
y =
Application.Substitute(x, .Range("Current_Function"), .Range("Selected_Function"))
Any ideas ?
- Ronald K.
|