#### chris2727272727

##### Board Regular

- Joined
- Jul 10, 2005

- Messages
- 152

Range("d14").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

Range("e14").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

Range("b18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

Range("c18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

Range("d18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

Range("e18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

Range("f18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

Range("d14").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)

i have the above code but when it runs the below error comes up why is that

run time eroor '1004' unable to get the vlookup property of the worksheetfunction class