Hi! I usually teach myself VB by recording macros and looking at the code to see how to do things. But when I tried recording a find/replace-all in another macro, it wouldn't record anything.

I have an excel file (Model) that is used all over the world in our company. I have another file (Data) that has all of the data here in Australia. The locals here want to keep the local category names so they understand what is held in each column. I'm mapping the data from Data into Model, including the changed category names (Table Headers). Within the Excel doc itself, all of the references automatically change, but the macros in the file Model keep the old Table Header names.

How can I write a macro that will change, for example, all of the references in the other macro from table headings Table1[Sales] to Table1[Sales Value]?

Thanks!