Macro to edit cells
I have cells in a row with formulas that have the number 25 in them, such as, for example for two of them: =Project1!E25+... and =Project2!G25-....
I need to go to the cell and edit out everything that appears after (to the right of) the 25, then accept the revised formula as is. It's never more than, say, 20 more characters to the right, in case that matters. Can someone (carefully, please) write me a macro that will do this on the current cell, then move one cell to the right and repeat until it gets to the last column in that same row?
Thanks so much!
Dean
|