replace absolute references
If the rows are already absolute
do a replace A$ with $A$ for all of the columns you wnay to make absolute then do a replace $$ with $ in case any oif the columns were already absolute. "BorisS" wrote: can I quickly find/replace all non existent absolute references (for different column letters), and replace them with absolute versions of that letter? Each different column reference, however, is matched with the same absolute reference to row (if that helps). In other words, I don't want to replace with the same thing, but rather I want the sheet to go through the logic of "when I find the references of f$16 and g$16, I should replace them with $f$16 and $g$16". Thanks. -- Boris |
All times are GMT +1. The time now is 11:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com