$$Excel-Macros$$ V look up error 1004

2009-07-06 Thread Balachander S
Attn Dave Daniel Please find the sample file and the requirement --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

$$Excel-Macros$$ V look up error 1004

2009-07-05 Thread Balachander S
Can some body in the group tell me why error occurs for V look up function Private Sub ComboBox3_Change() 'accno = ComboBox3.Value Workbooks.Open Filename:="h:\credit\Limits of rs 25 lacs and over" Worksheets("sheet1").Activate ccode = WorksheetFunction.VLookup((accno), Range("q4:w570"), 5, False