View Single Post
 
Old 03-23-2019, 12:28 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

re:" in the complete sheet instead of only in the range".


This happens when a single cell is effectively being operated on by Replace, so I'm just wondering whether somehow that's what's happening here; are columns F:H in a row merged cells? Is there only one row that it's operatimng on because there's only vone line of data?
Could you make up a file where you have this happening, but attach it here in a state before any replacing has been done? It will make it a lot easier to investigate.
Reply With Quote