Thread: Find #N/A in column D
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
  
Posts: 173
Default Find #N/A in column D
Howard,

Try:

Range("D1:D" & Range("D" & Rows.Count).End(xlUp).Row) _
..SpecialCells(xlCellTypeFormulas, xlErrors).Count

Ben
Reply With QuoteReply With Quote