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.
|