Hey Guys,
Need some help with a VBA code. All the methods i've been using aren't working out to well. Can someone make a script that looks into every cell of a workbook and deletes the information between " ' " and " ] " and including the " ] ". Let me know if this is possible.
Problem stems from a file path that needs to be deleted but the formula to stay intact within a cell.
Thanks,
If the file path is the same in all cases (or you only have a few different file name/paths), you could probably do this with a few steps using Find/Replace
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
Yep, that's my current process, but was looking to click a button and have it all done automatically. I tried a code to list the file paths on a new sheet then find and replace automatically but the list left out the brackets " [ " " ] " so didn't end up finding the others.
You would need to include all the text/name/path that you want to replace/remove
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks