The Excel 2010 Advanced Filter adds database functionality to Excel, you can query by example and style custom reports with this feature. … [Read more...] about Excel 2010 Advanced Filter Tutorial
All Articles
Power Excel vba secret, avoid using select
I see it all the time, code that selects one thing, then another, then selects something else in order to navigate and write data in an Excel spreadsheet. Instead understand that the Microsoft Excel object model and your vba code will be more professional, robust and maintainable if you don't select anything but instead interact with the Excel objects directly. Check out … [Read more...] about Power Excel vba secret, avoid using select
Is your site indexed by Google ?
You have put up you site or contributed to your blog. But you don't yet know if it has been submitted to Google. In order to check you site ranking all you have to do is type the following into the search engine... site: yourdomain.com Google will then list in the serp (Search Engine Results Page) the total number of pages indexed and all pages from you site that are in the … [Read more...] about Is your site indexed by Google ?
How to code a vba form without using global variables
Global variables ruin applications Here is how to code a form without using those dreaded globals.This is especially useful for forms that must appear in the middle of a running process, and that need to collect information from the user and then pass the user's choice back to the calling code and continue running. … [Read more...] about How to code a vba form without using global variables