Find "TEXT 1" in a range and enter "TEXT 2" in the adjacent cell
I'm trying to write a macro that will look at a certain column range (column A) and find all cells with value "TEXT 1". For all those cells with value "TEXT 1", the macro should enter "TEXT 2" to the cell adjacent to it (to the right).
Thanks,
Madreag
Hello madreag,
Welcome to the Forum!
Is there some reason you can not use a formula in the adjacent column to do this?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi,
Do you really need a macro. Why not in B1 just
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi and welcome to the forum
You dont need a macro for this, a simple IF() will do it for you
assuming you want to start this in B2...
=if(A2="Text1","Text2",A2)
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the welcome!
We could use a formula, but I would like to keep it simple to the end user; it would be nice if all they had to do was run 1 macro.
Also, I will be inserting this macro as part of a larger one.
EDIT: I don't think we can use a formula since some adjacent cells are already filled or blank.
Last edited by madreag; 06-28-2013 at 05:03 PM.
hmmm...run a macro....do nothing and the formula does what it is supposed to do....
I would have thought the "do nothing and the formula does what it is supposed to do" would have been pretty simple?
In that case just encapsulate the formula in a macro. e.g.Originally Posted by madreag
Please Login or Register to view this content.
Richard,
your macro does the job, but it also clears all the other cells from column B. Is there a way to only affect the cells adjacent to TEXT 1?
Maybe the best way to do this would be to do a find TEXT 1 macro and use .offset(,1) to change the adjacent cells only? How would I put this in a loop?
something like this that loops?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks