Counting cells with Invalid Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting Invalid entries 1
Printing Invalid Data Circles 1
count cells with diagonal borders 3
Count number of cells with data validation errors 3
Prohibit duplicate data in a cell 1
Trapping invalid dates 4
Count invalid data entries 6

Back
Top