Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Searching for text within formula
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="isabelle, post: 3870793"] hi Ronald, Sub Macro1() x = Sheets("Sheet1").Range("First_Cell").Formula y = Application.Substitute(x, "PRODUCT", "SUM") Sheets("Sheet1").Range("First_Cell").Formula = y End Sub Sub Macro2() x = Sheets("Sheet1").Range("First_Cell").Formula y = Application.Substitute(x, "SUM", "PRODUCT") Sheets("Sheet1").Range("First_Cell").Formula = y End Sub [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Searching for text within formula
Top
