Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find Replace Number Starting with 0
I am trying to find and replace a list of numbers that begin with zero. I
can't get replacement function in this code to display the zero. Sub FindReplace() Columns("J:J").Select FindReplaceDPT 144, 141 FindReplaceDPT 147, 151 FindReplaceDPT 149, 151 End Sub Sub FindReplaceDPT(Find, Replace) Selection.Replace What:=Find, Replacement:=Replace, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find and replace a number with a minus sign in front? | Excel Discussion (Misc queries) | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
Can I use Find and Replace all with Hyperlinks? | Excel Discussion (Misc queries) | |||
find replace cursor default to find box | Excel Discussion (Misc queries) | |||
How do I find the first value in a column less than a number? | Excel Worksheet Functions |