tigger6333
New Member
- Joined
- Sep 6, 2009
- Messages
- 43
Can anyone please give me an example of a Macro to:
1) Do a find and replace on a worksheet AND
2) Do the find using the contents of one cell AND
3) Do the replace using the contents of another cell AND
4) Do all this on another cell that contains a sentence AND
5) Only change the word required, keeping the rest of the sentence the same.?
My searching in the forum has served to perplex me further than I already am.
My lack of VBA skills is hindering me, but I am determined to learn. Any example of what I
need will serve to help me learn.
Thanks
tigger6333
1) Do a find and replace on a worksheet AND
2) Do the find using the contents of one cell AND
3) Do the replace using the contents of another cell AND
4) Do all this on another cell that contains a sentence AND
5) Only change the word required, keeping the rest of the sentence the same.?
My searching in the forum has served to perplex me further than I already am.
My lack of VBA skills is hindering me, but I am determined to learn. Any example of what I
need will serve to help me learn.
Thanks
tigger6333