I have some code that I want to use to check for the value of #N/A in a cell... it is...
If ActiveCell.Value = "#N/A" Then
However... I keep getting a "type mismatch" when I try to run it. And yes, the cell valus is #N/A.
I have even tried...
If ActiveCell.Value = "N/A" Then
To no avail. Any help in pointing me in the right direction would be greatly appreciated.
Dennis
Results 1 to 3 of 3
-
Star Lounger
- Join Date
- Sep 2001
- Location
- Blue Springs, Missouri, USA
- Posts
- 92
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-01-24 17:02Checking for cell value #N/A (XL97)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
WS Lounge VIP
- Join Date
- Dec 2000
- Location
- Burwash, East Sussex, United Kingdom
- Posts
- 5,790
- Thanks
- 0
- Thanked 68 Times in 64 Posts
2002-01-24 17:14Re: Checking for cell value #N/A (XL97)
Hi,
Try:
If Application.WorksheetFunction.isna(activecell.Valu e) = True Then
Hope that helps.Regards,
Rory
Microsoft MVP - Excel.
-
Gold Lounger
- Join Date
- Feb 2001
- Location
- Dublin, Ireland, Republic of
- Posts
- 2,697
- Thanks
- 1
- Thanked 0 Times in 0 Posts
2002-01-24 18:17Re: Checking for cell value #N/A (XL97)
Although Rory's suggestion will work, an alternative might be
If ActiveCell.Text = "#NA" Then
Andrew C
