Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Equivalent Code in VBA (03)

    If Cell A1 contains "123Help" and Cell B1 contains the formula "=ISERROR(VALUE(A1))" the result returned in Cell B1 is TRUE.

    What would be the equilavent code in VBA? I tried "=ISERROR(Range("A1").value)" and a number of other attempts lead me to be challenged with "VALUE".

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Equivalent Code in VBA (03)

    You could use

    Not IsNumeric(Range("A1"))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •