Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- LowKey ------------------------------------------------------------------------ LowKey's Profile: http://www.excelforum.com/member.php...o&userid=15273 View this thread: http://www.excelforum.com/showthread...hreadid=269870 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit many cells at once to add a charater to existing data? | Excel Discussion (Misc queries) | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
How do I add another name to an existing table with formulas to w. | Excel Worksheet Functions | |||
HOW DO I EDIT AN EXISTING FILE TO BE SPACE DELIMITED? | Excel Discussion (Misc queries) | |||
Excel open an existing MS Query in edit mode via macro attached to a button. | Excel Programming |