Excel VBA function range.replace

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Excel VBA function range.replace

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-25-2019, 03:09 AM

p45cal

Windows 10 Excel VBA function range.replace

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

try adding one line before your With..End With block:

Set dummy = Worksheets(1).Range("A1:A1").Find("Dummy", LookIn:=xlValues)
With Columns("F:H")
.Replace What:="Dec", Replacement:="Dez", LookAt:=xlPart, ....

and report back.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:19 PM.