See attached workbook.
For some reason on the Stats Worksheet I am getting #VALUE! but if I click on the cell then up in the formula bar and hit enter it works. Is there something I can add to my VBA to avoid this inconvenience?
Hit the Button on top of the stats page to make the magic happen
07. Employee Safety Statistics for forum.xlsm
Add the provided line to your code.
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
I'm away from the computer right now. When I tried this it screwed up the countcellsbycolor in the other sheets, SOS which dont use on button click. I would like those to update whenever I copy and paste or change a grey cell to no fill also.
Ill test later. Thanks for the support!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks