iserror in vba.

  1. Grizlore

    Looking up a "banned" item from a Userform with VBA lockup

    I am looking for some help please, I am sure it is something simple. When I enter a numerical value into the Userform textbox "txtRTAs" I would like it to look at a worksheet to see if the number is there. IF it is, then I want a simple MsgBox to inform that this number is there and "banned"...
  2. L

    EVALUATE function crashing

    I have a couple of macros that have been running weekly for over 2 years. However, the first time they have been run this year the EVALUATE line crashes in the following piece of code: Dim deleteStudent As Boolean deleteStudent = Evaluate("IsError('Student Data'!1:1)") If...
  3. D

    IF ISERROR and FIND based on multiple criterias

    Hello, please help me, im stuck. So here is my table: Table 1: EE Name(A1), prospect name (B1)(name is very long, i.e: AEM-xxxxxx, AEM-yyyyy, AEM-Advanced,etc..., AEP-xxxxx, AEP-zzzz,.... (AEM, AEP...are client names) Table 2: EE Name (C1), prospect abbreviation (D1) I need to abbreviate...
  4. J

    use ISError when using a defined name - correct syntax?

    to all I rather than hardcoding a column in my vba script I am using a defined name to get the column using iRefCol=Range("RF1RefCol").Column) where RF1RefCol is the defined name this works fine I now want sto capture the possibility of the define nam enot existing in the xls (deleted by...
  5. M

    Run-time error '1004'

    I can't figure out how to get rid of the Run-time error '1004': My VBA code is supposed to write a simple ISERROR-function to the worksheet. When I type it manually and record a macro the code reads:ActiveCell.FormulaR1C1 = _...
  6. A

    If(ISERROR

    Hi - I can't seem to get the ISERROR to work in VBA. Numerator = X Denominator = Y Fraction = X/Y X and Y varies in my macro (loops through loads of data). Sometimes Y will be zero and my macro fails. I want to apply the IF(ISERROR function: Fraction = IF(ISERROR((X/Y),0,(X/Y)). But I only...
  7. J

    ISERROR Runtime error "1004" issue

    I have been trying to get this code to work for 2 hours now. I have to columns of dates/times that I need to find the difference between and put that variable in another column that is formated as time. If there is a blank cell in either of those columns it gives me a #Value error. I'm trying to...
  8. G

    iserror in VBA.

    Hi, i have been trying to handle the error in vba for last two days and have tried all the possible option i know but unfortunately not got rid of this error till now. below is the code- if not iserror(Application.WorksheetFunction.Rank(Cells(a, 24), Range("x:x"))) then Activecell.value =...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top