iferror in macro

**capngene** · 02-10-2012, 09:28 PM

I have a macro where I'm trying to find the position of "E" or "H" in a variable length string, Bookname. Bookname has either an E or an H but not both. I tried using an IF statement

EHPosition = if(iserror(instr(Bookname,"E")=TRUE, EHPosition = instr(Bookname,"H"), _ 
EHPosition = instr(Bookname,"E"))

but I get "Expected Expression" on the IF.

I then tried

 EHPosition = IfError(InStr(BookName, "E"), InStr(BookName, "H"))

but I get "Sub or Function Not Defined" for the IfError.

What to do?

**protonLeah** · 02-10-2012, 10:27 PM

Insr() returns 0 if not found, therefore:

EHPosition = InStr(BookName, "H")
If EHPosition = 0 Then
    EHPosition = InStr(BookName, "E")
End If

Thread: iferror in macro

Thread Tools

Display

iferror in macro

Re: iferror in macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions