View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default finding error in range

Is there a way via formula (not code - as I want it to refresh on every calc)
to find if there is an error in a range.
I tried an array formula - but woking only for the first cell (B5)
{=ISError(B5:G5)}
Many thanks,
Dan