Hi Arlette,
Thank you but it's got run time error '438': object does not support this property or method.
after press debug button, this line "If InStr(Wk, "ALVX") <> 0 Then" has yellow coloured.

any other alternatives suggestion??

Thank you .