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.
Re: Find text, if not paste 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 logs below. in this case line 7.
Last edited by davesexcel; 05-12-2012 at 08:42 AM.
Re: Find text, if not paste in the first blank cell
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?
Re: Find text, if not paste in the first blank cell
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?
Last edited by davesexcel; 05-12-2012 at 09:15 AM.
Bookmarks