Find text, if not paste in the first blank cell

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.

What 1st blank cell do you want the value? Is it a specific row or a specific column?

When this is explained, you do not have to paste the value.

1st blank row=datafind

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 logs below. in this case line 7.

you can put directly in the project because I am afraid of doing something wrong.
thank you

Your code loops through all the sheets in your workbook searching for the the inputbox criteria, is the inputbox criteria supposed show up on each worksheet that returns no results?

I made the change as you said, but nothing done. it does not puts the word in the right direction. and do not stop the search for value.

You do not have to quote every single post.

with this macro is already putting the word when it is not found, but does not select the word when it already exists.
thank you for your help.
let's see if I can do that select pre-existing words.
I'll have to put this macro with one of the parties of my first macro. correct?

Originally Posted by StevenM

Select cell found selected.

Please Login or Register  to view this content.

thank you very much, is excellent.

one more thing. is it possible the cell where the word was inserted by not being available, be selected. such as when the word is already there.

is it possible the cell where the word was inserted by not being available, be selected. such as when the word is already there.

Please Login or Register  to view this content.