Would you be able to post your code...

If this post helps click Yes
---------------
Jacob Skaria


"ub" wrote:

Hi
I have a VB code to find a value in the cell.
When I use the debug tool, it works fine and displays the value, but when
the macro is running , it is unable to find the data.
I am using Excel 97.
Thanks