Macro to edit existing formulas
 

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",Exe c!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

--
LowKe
-----------------------------------------------------------------------
LowKey's Profile: http://www.excelforum.com/member.php...fo&userid=1527
View this thread: http://www.excelforum.com/showthread.php?threadid=26987

Macro to edit existing formulas
 

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.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"LowKey" wrote in message
...

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

=cfi($M$2,$N$2,B467,C467,D467,E467,"S","M","0",Exe c!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 should
continue until the cell is blank.

Thanks in advance for any help

LowKey :confused:


--
LowKey
------------------------------------------------------------------------
LowKey's Profile:
http://www.excelforum.com/member.php...o&userid=15273
View this thread: http://www.excelforum.com/showthread...hreadid=269870