Hi
I have a set of data in which asterisk is used as a separator. Asterisk being a wildcard character hinders with my search operation. I used the following code to replace the * with | as the separator.
When I run the code, it replaces all the asterisks in the sheet. I want to restrict the find and replace operation to a particular column (say B:B) / range (say A1:C10) alone. Is it possible to do that?
Please Login or Register to view this content.
Last edited by indimonk; 01-31-2012 at 05:26 AM. Reason: Marked as solved
Please Login or Register to view this content.
Last edited by protonLeah; 01-31-2012 at 12:14 AM.
Ben Van Johnson
Hello indimonk,
If you want to check only cells "B1:B10" in the Range("A1:C10") then the macro would be...
Please Login or Register to view this content.
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!)
Thanks protonLeah. It works perfectly now. When I used Chr(42), it replaced the entire content of the cell. I have therefore continued to use ~*Originally Posted by protonLeah
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