Office applications and Web browsers – Tips and macros that make life easier
When you might need to apply color sales Conditional Formatting to multiple rows in Excel using a Macro? We found that is most useful, when you have a perfectly arrange row-by-row conditional formatting, and you are trying to insert a new row. You can try to fix the resulting formatting […]
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 […]
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 […]
Before I forget, let me share with you a fantastic way to read values from Registry into a batch file variable. Say you need to determine, what is the date format of this machine. Normally you would read a value from HKEY_CURRENT_USER\Control Panel\International like this: REG QUERY “HKCU\Control Panel\International” /v […]
Problem started as a simple CAN’T CONVERT NUMBER INTO A STRING in Excel. But solving this problem revealed a deep difference between character Space and character No-Break Space. I was copying some text from Internet and pasting it into Excel to extract QTY, Amount and Total. The ultimate goal is […]
I hope this post will help a lot of frustrated users out there. PROBLEM: IE10 was working fine, but at one point it stopped saving user names and passwords for web sites. This most securely-configured browser, so switching was not an option. Here is my solution. Please see, if it […]
Do you hate an extraneous search box that is cluttering your valuable real estate space in an IE address bar? This article was tested with IE8 on Windows XP and Windows 7. Remove Search box using gpedit.msc If you are using IE8, there is a simple way to remove […]
This Excel macro allows changing cells in selection based on the first cell in a selection: If Selection.Cells(1, 1).WrapText = True Then Selection.WrapText = False Else Selection.WrapText = True End If This is useful in Excel 2003 and bellow. Starting from Excel 2007, there is a button to perform […]
Adobe Creative Suite 5 Design Premium Adobe Photoshop® CS5 Extended Adobe Illustrator® CS5 Adobe InDesign® CS5 Adobe Flash® Catalyst™ CS5 Adobe Flash Professional CS5 Adobe Dreamweaver® CS5 Adobe Fireworks® CS5 Adobe Acrobat® 9 Pro * Adobe Bridge CS5 Adobe Device Central CS5 12 years in Software is longer than life. […]
Time to Try New Things I just learned that 45% of all my visitors (over the last week) are using Firefox (FF). And only 5% stayed with Internet Explorer (IE). So, after all these years I am finally ready to try this one. I downloaded and installed Firefox 3.6.11. By […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor