My colleague and I use the Macro I'll paste below to pull out highlighted yellow cells and add them to another sheet that the Macro creates. For some reason, it has stopped working on his computer. When he runs the code, he gets an "Invalid Outside Procedure" error and it highlights "Application" in the code. Application is used several times within the code, and when I had him delete the first instance of it, it gave the same error and highlighted the next one. I don't understand why it would suddenly stop working for him, and continue working for me. See the code below:
Bookmarks