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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
