Remove the * from the SubCate, Custom Sort, Replace..Help Please

whatsup · #2 07-08-2014, 12:11 PM

Hi

If you want to search or replace a sign like * you will have to search for it like that:

Code:

Cells.Find(What:="~*", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
        , SearchFormat:=False)

Code:

ActiveCell.Replace What:="~*", Replacement:="1", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to use find and replace to change text to a custom style	wrdy	Word	7	03-11-2014 12:09 AM
Custom table of contents referencing a custom field	skaboy607	Word	3	01-16-2014 06:59 AM
remove color from find/replace?	Cobb78	Word	1	05-26-2012 06:16 PM
quick replace, sort, change columns	userman	Excel	1	05-01-2012 06:24 AM
Generic range for custom sort macro?	tswiers	Excel Programming	2	08-11-2011 02:40 AM