ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find Replace Number Starting with 0 (https://www.excelbanter.com/excel-discussion-misc-queries/54780-find-replace-number-starting-0-a.html)

Amir

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


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com