Windows

*** Use Wildcards with REG DELETE (Almost) ***

I loved writing this article.  You will se here the power of good old batch commands.  Amazing! Say, I am trying to resolve a problem in a registry.  To isolate the problem, I need to delete hundreds of branches from an externally loaded Registry hive QQ\Classes from a parallel instance. For […]

Office and Browsers

Properly Validate TextArea Length (IE vs. Firefox)

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX.  When user types inside TextArea, Inbox should show the length of TextArea string. <script type=”text/javascript”> function TTLength(objTT){ var tt= document.getElementById(‘TXT1’); tt.value = objTT.value.length; } </script> <textarea onKeyDown=”TTLength(this);” onKeyUp=”TTLength(this);” rows=”10″> This Text Area Contains a string With Newline […]

No Picture
Office and Browsers

Count Number of Cell with Errors in Excel

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count how many errors are […]