Hi bohi Since only cells with 1 will turn Gray, you might as well just count all the cells with 1's.
Sorry, missed the file
Hi Jim There is no reason why it is not working as your formula is correct. Take a look at my attached file.
This is one I frequently use. It allows only numbers and nothing else (not even a space) to be entered into TextBox1. Private Sub TextBox1_KeyPress...
Glad I was able to assist you. Cheers Sunny
Wow Tony !!! I'm impressed with your idea.Not bad for a VBA "novice". You could consider add this line of code to get the FinalRow instead of defi...
Hi Tony If your value is fixed, you could be better-off using a VLOOKUP on the Building Desc for the Building Code. Referring to your quote "Tha...
Hi Tony I am unable to visualize what you want.I hope this is the code you are looking for, otherwise I hope other members can assist. The codes...
Hi Tony I am just making a guess here based on your data given. Correct me if I am wrong. 1) Columns E (Building Desc) and G (Floor Desc) are ke...
Hi Tim I believe there are always more than one way to do what you wanted. PT is only my suggestion as it is easy to use (especially when dealin...
Hi Tony It would be great if you could post a sample file with as much data as possible and the expected results for us to see. It will be easie...
You could try this =SUBSTITUTE(ADDRESS(1,<your column number>,4),"1","")
I set both Worksheet_Activate() and Worksheet_SelectionChange(ByVal Target As Range) events to hide the Tabs
Thanks for the link. Done that before a couple of times. Lots of hiding and displaying sheets in my case. I guess it is just a matter of prefer...
I agree with you Catalin that you cannot force user to enable macros. We can find many work-arounds but all will fail because of this. From my own ...