Subscript out of range with find function

[cferoiu]

I try anithing , I don't know were I wrong.
I think problem start with my try to find procedure in another sheet (not active one).
I need to find method for not active worksheet!!!
Any help apreciated.

[TMS]

Please post a sample workbook with some typical data and the code in context ... not just a picture of highlighted code line.

Regards

[cferoiu]

Thank you for your intention.
I FINALY find the problem... I use xlValue , must use xlValueS.
But i stil have a problem with find method.
I have a column V in sheet("WEB") with same formula which calculate DATE , find function not find any DATE in my column.

[TMS]

Try:

Please Login or Register  to view this content.

Regards