Hello Dear community,
I used Macro recorder to select range and replace specific character.
But how can I change range, so when I run this VBA from another sheet it will still work. Because right now when I run this macro from different sheet, it pop-ups non-stop.
Please Login or Register to view this content.
Append your worksheet reference to your range method. For example,
Please Login or Register to view this content.
You can make it a little cleaner and run a bit faster if you change it to this:
Please Login or Register to view this content.
If you find the suggestion or solution helpful, please consider adding reputation to the post.
Both solutions works, thank you
There was problem with this code. I can't understand why.
I get error "Run time error "1004" : Appilcation defined or object-defined error.
Can any one tell me what is problem?
Note: DATA-MOBILIZ is hidden sheet.Please Login or Register to view this content.
Not sure why, but i copied your macro into a new spreadsheet and it ran fine, i named the sheets like yours and added some values in E and it found and replaced the -
No error
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks