|
|
|
|
#1
03-25-2019, 03:09 AM
|
||||
|
||||
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. 
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Hybrid Mode