Excel VBA function range.replace

Debaser · #1 03-21-2019, 07:02 AM

Perhaps you have merged cells? Avoid selecting anyway:

Code:

with Columns("F:H")
.Replace What:="Dec", Replacement:="Dez", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=True
.Replace What:="Oct", Replacement:="Okt", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=True
.Replace What:="May", Replacement:="Mai", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=True
.Replace What:="Mar", Replacement:="Mär", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=True
.Replace What:="-", Replacement:=".", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=True
End With

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using IF Function where logical test is for range of values	guciolino	Excel	10	02-13-2017 08:05 AM
Help with Index Function to Select Range of Cells	bretyuin	Excel	1	02-24-2016 05:11 AM
Using Left function to format a range	USAOz	Excel	4	09-10-2015 03:00 AM
Find and Replace using Excel range	dmarie123	Word VBA	15	04-02-2013 07:54 AM
Find and Replace within range	anil3b2	Word VBA	3	12-01-2010 02:35 AM