hello. I'm trying to make a macro to find a specific text, and if not available, this same text to be inserted into the first blank cell.
The macro to find Is already inserted in the project, now I just need the part of in case does not find the text, paste it in the first blank cell.
what I want to do is place the text, not found in the first blank cell in column A. in this case line 7 of column A.
For example: if you do not find the word "line" in column A, the macro would paste that word in the blank line immediately below. in this case line 7.
first of all thanks for the help.
Bookmarks