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