I just started with a new company and checking their VBA codes and I noticed that they haven't been using table references and were using R1C1 references.
Is there a way for Excel to update automatically so that the code changes all R1C1 references to table form (i.e. IF([@[Line of Business]]=""Motor"",[@Product],[@LOB]))?