Thread: hide "#VALUE!"
View Single Post
  #1   Report Post  
Brian
 
Posts: n/a
Default hide "#VALUE!"

My worksheet is linked to a web query and the value of many cells is
"#VALUE!". The message is "value used in formula is wrong data type". Due to
the nature of the web query, I can live with this without making changes
however I would simply like to "hide" or show a blank cell if the cell shows
this message. I apprectiate suggestions to do this. Thank you.