Re: $$Excel-Macros$$ VBA & vlookup issue

Dear teow, can u share a workbook with us?? Regards, Gawli Anil On Wed, Nov 21, 2012 at 4:34 PM, Teow wrote: > > > when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, > but if change to network path " & ThisWorkbook.Path & > "\[WSO_Record.xls]Record, i will get error 1004

$$Excel-Macros$$ VBA & vlookup issue

when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, but if change to network path " & ThisWorkbook.Path & "\[WSO_Record.xls]Record, i will get error 1004, what is the error in my script? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Ta