Thread: Counting cells with Invalid Data

XL2003

I am circling invalid data at the end of my worksheet_change event so the
user can see what is wrong. Is there a way to count, or even a boolean
command so I know not to show the user the final tally?

Depending on which cell has invalid data, sometimes the spreadsheet will
still calculate it's total values. If I could paste a count (TRUE) into cell
E50, then E49 could be set to only display the total if E50 is zero (FALSE).

TIA, Brad

It depends upon what determines invalid, but all you need to do is loop
through the data and test against that rule, incrementing a counter as you
go.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brad E." <BradE@discussions.microsoft.com> wrote in message
news:B7AE9C60-136B-4A6E-A07F-208EEC8F55EF@microsoft.com...
> XL2003
>
> I am circling invalid data at the end of my worksheet_change event so the
> user can see what is wrong. Is there a way to count, or even a boolean
> command so I know not to show the user the final tally?
>
> Depending on which cell has invalid data, sometimes the spreadsheet will
> still calculate it's total values. If I could paste a count (TRUE) into
cell
> E50, then E49 could be set to only display the total if E50 is zero
(FALSE).
>
> TIA, Brad