This macro used to work perfectly fine.
We use it to replace about 1000 different items in a column on an inventory spreadsheet from a supplier.
Unfortunately, it now returns this error message...
We have a separate file that we keep this chart in.
Below is the code we used for it. Can...