how to select a range of cells in vba and compare if all their value is equal to #N/A
I am new to Macros so any help would be appreciated.
I have a sheet in my work book which displays the output.
the output is in the range D11 to M151.
I would like to display a message box saying "output not handled" when all the values in this range is
Please help me its urgent
Solutions to the Problem how to select a range of cells in vba and compare if all their value is equal to #N/A
Dim rng1 As Range
Dim rng2 As Range
Dim rng3 As Range
Set rng1 = Range("D11:M151")
On Error Resume Next
Set rng2 = rng1.SpecialCells(xlCellTypeFormulas, xlErrors)
Set rng3 = rng1.SpecialCells(xlCellTypeConstants, xlErrors)
If Not rng2 Is Nothing Then
If Not rng3 Is Nothing Then
Set rng2 = Union(rng2, rng3)
ElseIf Not rng3 Is Nothing Then
Set rng2 = rng3
If rng1.Count = rng2.Count Then
MsgBox "Output not handled!", vbInformation
- Open Internet Explorer.
- Go to "Tools > Internet Options > Advanced Tab".
- Uncheck "Enable third-party browser extensions".
- Click "Apply".
- Reboot your computer.
Another Safe way to Repair the Problem: how to select a range of cells in vba and compare if all their value is equal to #N/A:
How to Fix how to select a range of cells in vba and compare if all their value is equal to #N/A with SmartPCFixer?
1. Download Error Fixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.
2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.
3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.
Related: Startup Error Failed to connect to a Windows service System Event Notification Service sic Task Scheduler not always closing down program text wrap not working in Word Upgraded my computer from Windows Vista to Windows 7 Now my Lexmark Z515 printer will not work Can someone please help me The drivers for USB 2 0 arent showing up and dont seem to be usable I have ServicePack s 1 thru 3 The drivers used to show and work but not any more Is there a way I can get them back so my 2 0 items will work properly Symbols are not displayed in PDF when word is converted to pdf using Save As PDF Microsoft Addin The Security Center has not recorded an antivirus product when tried to generate System Health Report When conducting a search on Google or Bin search results are not visible I get a blank white page Ulead Photo Express 5 SE does not work with Win7 USB 2 0 devices plugged into USB 3 0 do NOT appear in Safely Remove HW VBA Excel find matching list files and copy to another folder What can I do to eliminate the not responding message I constantly get Web Proxy Not Responding USB Microsoft Mouse Not working upon boot whatsapp not connecting What should I do if my CD Drive reads some CDs but not others,Issues With Downloads And Installations Since Fresh Install Of Windows 7 64bit,Windows 8 - Browsers Font Rendering Issue! Blocky Fonts Text,Why Some Of Links Are Not Functioning In Web Pages (IE8)?,Internet Stops Working,Nesting Functions???,IMesh Is Not Working Only Minimizes,I Can't Uninstall ITunes And SupportSolutionsFramework.msi,I Have 3 Columns Out Of Many Columns Of Data Each With Hundreds Of Rows, I Need To Identify The Lowest Number In Each Row For These Three Columns Only And Reference The Column Title For That Particular Number.,Divide Information Into Two Columns,My Asus T100 Transformer Wont Turn On
Read More: hi if i am using a wirelesskeybord an need to turn on my wifi how do i do it? [Solved],How to Fix - How do i fix my windows 7, it keeps crashing with Blue screen along with BCCode: 1a?,[Anwsered] Decimal defiance,EMI BY NEW METHOD [Solved],Solution to Error: Windows 7 USB Drive with RAW partition.,Alps pointing device stops working and resumes.,Attempting to use Conditional Formating with a variable,internet options not opening on IE 10,cannot open my emails. they are there but will not open,Microsoft Works 9 does not keep History items.