Thread: Indication that there is a # cell value in the range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
  
Posts: 897
Default Indication that there is a # cell value in the range
Selection.SpecialCells(xlCellTypeFormulas, 16).Select


HTH,
JP

On Jan 10, 12:19*pm, avi wrote:
Hello,

I look for a very fast code that will indicates the presence of at
least one #N/A, #DIV!....in a range the user select

Thanks a lot
Avi

Reply With QuoteReply With Quote