Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find #N/A in column D
This finds blank cells, if any, in column D and makes note of such in a msgbox.
How can I do the same with #N/A's in the same column D. The #N/A's, if any, are a result of formulas. I tried altering the formula to produce "" instead of #N/A but still cannot sniff out those cells to include within the msgbox. Option Explicit Sub DcEmptyCells() Dim i As Long Dim j As Long Dim ws As Worksheet On Error Resume Next i = Range("D1:D" & Range("D" & Rows.Count).End(xlUp).Row) _ .SpecialCells(xlCellTypeBlanks).Count If i 0 Then MsgBox " You have " & i & " blank(s)." & vbCr & _ "In need of update column D:D.", vbOKOnly, "Blank & N/A" End If End Sub Thanks. Regards, Howard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find #N/A in column D
Howard,
Try: Range("D1:D" & Range("D" & Rows.Count).End(xlUp).Row) _ ..SpecialCells(xlCellTypeFormulas, xlErrors).Count Ben |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find #N/A in column D
On Tuesday, December 18, 2012 5:08:30 AM UTC-8, Ben McClave wrote:
Howard, Try: Range("D1:D" & Range("D" & Rows.Count).End(xlUp).Row) _ .SpecialCells(xlCellTypeFormulas, xlErrors).Count Ben Thanks,Ben. I had gone to help to see if I could get a list of the ".SpecialCells(xlCellType...., xl#N/A)". Had no luck. I'll try again. Your suggestion will for sure do the trick. Thanks again. Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find last row value in column when using MATCH to find column | Excel Worksheet Functions | |||
Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Find specific column titles and copy the column to new workboo | Excel Programming | |||
Find specific column titles and copy the column to new workboo | Excel Programming |