Ask Experts Questions for FREE Help !
Ask
    Capuchin's Avatar
    Capuchin Posts: 5,255, Reputation: 656
    Uber Member
    		  
    #1

    Mar 30, 2007, 05:35 AM
    VBA targeting #Ref!
    I want to determine if a cell has returned the #REF! Error using an if statement, I have no idea how to address this.

    I've tried:
    Code:
    If [Cell] = "#REF!" Then....
    To no avail, returns a type mismatch, any other ideas? :)
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Mar 30, 2007, 06:45 AM
    Try this:

    If Evaluate("=ERROR.TYPE(" & Address & ")") = 4 Then
    action code
    End If
    Capuchin's Avatar
    Capuchin Posts: 5,255, Reputation: 656
    Uber Member
    		  
    #3

    Mar 30, 2007, 07:28 AM
    Same problem, type mismatch :/
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

VBA and Excel for office97 [ 1 Answers ]

I have created a form in Excel using VBEditor in Excel and want to use the form to transfer data to Excel spreadsheet. I create an Excel file. Whenever the file is opened I want the form to load automatically. Then I use the form to enter data in specified cells. When I am through posing the data,...

AC vs Ref [ 2 Answers ]

1. What is the difference between air conditioner and Refrigerator - by cycle,by parts. Can refrigerator be used as a air conditioner. If not why? 2. How humidity is controlled in air conditioner. 3. Which part does the work of humidity control in AC and how - compared to that in Refrigerator.

View more questions Search