View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] brett.kaplan@gmail.com is offline
external usenet poster
 
Posts: 48
Default Vlookup Error in Visual Basic

Hi,

I want to check to see if I get an error using VLOOKUP in visual basic.
If I do, I want something to happen; if not, skip over that step.
This is how I have it set up right now:

If IsError(Application.WorksheetFunction.VLookup(Cell s(4, 5).Value,
CDSPremiumsRange, 1, False)) = True Then
....

However, when it gets to this step and it is an error, I get a runtime
error message instead of it going to my code for what happens when that
If statement is true. Can someone help??

Thanks!