This article is about time saving, when it comes to enable your macros in Excel every time you open the file. You do not want to allow all macro to run. But if you don’t, you have to constantly enable your macros over and over again, when you open your […]
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 […]
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 […]
I never can’t remember the Notepad equivalent of “F3” (Find Next) in Word and Excel. Here are the keyboard shortcuts, that are most useful, but almost impossible to remember. Also I constantly need Euro currency symbol (€) and Temperature Degree symbol (°), when writing my travel notes about Europe. […]
These two macros will save you a lot of time. They used, when you need to copy something from Internet page into a Word or Excel document, but you do not need all the colors and formatting. You just need the text. Usually you would do this with Paste Special, but […]
We would like to add a horizontal line to the header of an Excel file to be repeated on every page. To add a horizontal-line we first need to create an image of a horizontal line in your favorite imaging software. Create a PNG image 660 by 3 pixels […]
This is a poor’s man manual on how to export Yahoo! group members list into Excel. Yahoo! used to have this simple feature right on their page, but it is gone now. Instead you would have to do this painful semi-archaic way of getting the data. To make it look […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor