Forum Discussion
Alan Curry
Sep 12, 2018Copper Contributor
Return the sum of formulas that contain a name
I have a spreadsheet where I have named cell N2 "STR" for Sales Tax Rate. Then I use STR in multiple formulas throughout the spreadsheet. Is there a way to search the spreadsheet for formulas th...
Lorenzo Kim
Sep 13, 2018Bronze Contributor
Mr. Curry
try these sites:
https://www.techrepublic.com/blog/microsoft-office/identify-which-cells-in-excel-are-formula-cells/
https://docs.microsoft.com/en-us/office/vba/api/excel.range.find
https://www.rondebruin.nl/win/s9/win006.htm
HTH
thanks..