Posts Tagged ‘ Blank ’

IE opens blank new tabs instead of your home page

2017/09/04
By
Modified: 2017/07/22
IE - Blank page on new tab

You have  masterfully designed custom home page for your Internet Explorer (IE).  All of a sudden, only first tab displays your home page.  All other new tabs in IE open as a blank page.  What happened?  Something is changing IE settings  back to “A blank page” ? This particular fix for this article was tested on Win7 x64 with IE9. In a few words, you need to delete this registry entry vprot.exe from location HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run   A little bit more radical solution is to run a 3 line script on Startup to delete all intruding entries from all 3 possible Startup locations in Registry. This solution is absolutely great, because it…

Read more »


Count Number of Cell with Errors in Excel

2017/06/17
By
Modified: 2017/06/15

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 in that column. Enter formula =SUM(IF(ISERROR(E2:E10),1)) and press Ctrl+Shift+Enter while still in editing mode. You should see two things.  First, your formula turns into {=SUM(IF(ISERROR(E2:E10),1))} with square brackets around it, and second, you got you a correct cells with errors count.  This is it. If you need to count cell without errors, you can use this formula: =SUM(IF( NOT( ISERROR(E2:E10)),1 ))…

Read more »