Mike Blackman
Well-known Member
- Joined
- Jun 8, 2007
- Messages
- 2,494
Hi All,
I have the following line of code which should replace all characters including and after the "@" but its just giving the whole value.
Can anybody possibly point out my error?
I have the following line of code which should replace all characters including and after the "@" but its just giving the whole value.
Code:
Replace(Application.VLookup(Sheets("Form").Range("C5"), Range("Lookup.Map"), 4, 0), "@*", "")
Can anybody possibly point out my error?