openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <>
Subject Re: Find errors in cells
Date Mon, 21 Oct 2013 17:12:34 GMT
At 18:34 21/10/2013 +0200, Johnny Rosenberg wrote:
>I am going to write a macro that finds cells with Err:522 in them 
>(in my case they are false errors and the macro is going to fix them 
>for me). Of course I can search the cells one by one, but it's time 
>consuming, so I thought I could use the built in find. When I run 
>find manually however, there doesn't seem to be a way to find which 
>cells have an error.
>So, is there a way to find the String value of a cell with the Basic 
>API, and not only values and formulas?

This doesn't answer your question exactly, but a workaround may be to 
insert an extra column - perhaps temporarily - and to use ERRORTYPE() 
to extract the number of any error.  You could use Find & Replace to 
locate that.

I trust this helps.

Brian Barker

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message