I have multiple excel files that contain superscript references in cells. I figured out a script that can ID and then convert superscript references to in the cells. It works with multiple refs in a single cell as well.
Unfortunately, right now it works on one cell. I would like to create a macro that loops through each cell in a used range and then calls a separate sub? Below is code for script that ID's and converts superscripts, need macro to loop this through approx 1000 excel files. Any suggestions welcome.
Bookmarks