Thread
:
finding error in range
View Single Post
#
1
Posted to microsoft.public.excel.programming
dan
external usenet poster
Posts: 866
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
Reply With Quote
dan
View Public Profile
Find all posts by dan