View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
XR8 Sprintless XR8 Sprintless is offline
external usenet poster
 
Posts: 19
Default Find a value in a sheet and replace it with another value ifit matches

On 2/09/2014 11:03 PM, Claus Busch wrote:
Hi,

Am Tue, 02 Sep 2014 22:53:51 +1000 schrieb XR8 Sprintless:

It errors at the Loop While Not f is nothing line after replacing the
first value.


try:


On Error Resume Next


Thanks, that seems to have resolved the issue.