What I'm trying to accomplish is to have the following code search from cell Q4 down to the last cell that is not null. The previous part of the macro ran an autofill of a formula that inserted either OK or ERROR in the cell. What I would like this function to perform is to search the range and if any cell has the word ERROR in it, a message box appears to inform me there is an error that needs to be fixed and the macro ends. The ElseIf returns a message box that No errors were found and to click OK to continue with the macro.
I've been searching and trying to piece this together myself, but it is now time to seek out help for more experienced people.
Bookmarks