| 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 |
| 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 | |||
Threaded Mode
