Hey guys, I'm trying to find an automatic way of finding a replacing a certain character from 2 columns. My excel template is extracted from a program I use, and this program ends up adding a "+" or "-" in front of its values.
I know I can hit Ctrl+H find and replace to remove it, but I was hoping there was a way for it to be done once the data is extracted automatically.
Ranges from E8:E94 and F8:F94, find and replace + or - with nothing. Any ideas?
Hi !
As VBA use the same Excel Find & Replace way so just activate the Macro Recorder and operate manually :
you will get your own free base of code ! …
Agree with Marc. With something this simple, you could use the macro recorder to get what you want.
Activate the recorder, go through all teh steps that you manually do - the recorder will record every step you do. Save the code, create a small button, attach the VBA to that, and you should be good to go.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks