I am writing a VB.net addin for excel.
I have a large workbook with many different worksheets. The workbook is composed of catalog type sheets and relational sheets. I want to change a value on the catalog sheet and for the change to be persisted throughout the rest of the workbook. However, I want to consider each cell before changing the value in order to not replace certain types of values such as cells with guids in them. For example:
I change "T0001" to "T9999" in my catalog sheet. In my relational sheet I have one cell value "T0001" and another cell with a value of "{b2dc9ad6-652d-431a-bdd8-2918172T0001}". I want to replace the first instance of T0001 but do not want to replace the T0001 that's found in the guid of the second cell's value. Is there a way to do this? Here is my code:
Bookmarks