Macro to edit existing formulas

  • Thread starter Thread starter LowKey
  • Start date Start date
L

LowKey

I have a spreadsheet with 500 rows containing formulas that look lik
this

=cfi($M$2,$N$2,B467,C467,D467,E467,"S","M","0",Exec!L$66)

I need a macro that can edit this formula by changing Exec to 'F&A'
move down one cell and do this same thing. This behavior shoul
continue until the cell is blank.

Thanks in advance for any help

LowKey :confused
 
From Excel's Edit menu, select Replace
Put your search and replace criteria into the supplied textboxes and Replace
All.

If you want a macro to do it, perform that operation with the macro recorder
activated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 1004 when trying to insert formula in cells 11
Is there a macro equivalent to cell function SumProduct? 4
Insert Formula based in cell user clicks 2
IF formula returns a very small negative number instead of zero 1
Scrabble Value calculation for Welsh words 0
Tweaking Existing Macro That Edits Long Formula with WORKDAY? 2
FormulaArray - Works in worksheet, not via Macros ? 2
Macro to insert formula using cell reference/text - Urgent 2

Back
Top