5 Excel Blogs You May Not Have Known About

There are a lot of Excel blogs out there, so I thought I'd highlight a few. These are blogs I discovered recently and thought someone out there might want to visit and see what they have to say about Excel programming.

1) Microsoft Excel Vba Formulas Tips and Tricks has some useful short code snippets to solve particular problems in Excel using VBA and worksheet formulas. In Protect Range of Rows and Columns in Worksheet with Macro you can grab some sample code that demonstrates how to programmatically lock and protect a worksheet area.

2) On Roy MacLean’s VBA Blog, there are several topics, with Excel VBA being one of them. In Worksheet vs. Custom VBA Functions, he tests out the hypothesis that worksheet functions are slower than custom VBA functions that perform the same task. Doug from NewtonExcelBach has information about this topic as well.

3) Excel Templates presents useful VBA code snippets for Excel. In Using Intersection to Create a Range in Excel VBA, you can learn how to create a Range Object consisting of the intersection of two separate ranges. Plus there is a UEFA Champions League spreadsheet that I'm planning to download and look at.

4) ExcelTips has VBA code samples for routine tasks you may need to perform. In Show a list in Excel with all files in a specific folder, a technique is demonstrated for looping through a folder on the hard drive and making a list of filenames on the worksheet.

5) On Yogesh Gupta's Excel Tips, there is a tutorial series not unlike the one I have here. Here is the Object tutorial which serves as a good introduction to Objects in VBA.

If you know of any other useful Excel blogs that might be underrated, let me know in the comments or send me a message.

Related Articles:

• March 21, 2011 -- Google Static Maps API in Excel
• February 7, 2011 -- Sending Faxes from Excel, What Gives?
• April 2, 2008 -- Quickly Clear Conditional Formatting