What particular blog posts do you come back to again and again?

[jeffreyweir]

Howdy folks. I want to write yet another blog post on Chandoo's blog in the near future about blog posts that are outstandingly good in their field. I mean one-of-a-kind good. Not just great, but Olympic Gold. I mean articles that you come back to time and time again.

For me, some examples are these:

• Referencing PivotTable Ranges in VBA :http://peltiertech.com/WordPress/referencing-pivot-table-ranges-in-vba/
• Using the Dictionary Class in VBA: http://www.experts-exchange.com/Sof...A_3391-Using-the-Dictionary-Class-in-VBA.html
• The Power of Variants: http://www.tushar-mehta.com/publish_train/book_vba/08 variants.shtml
• Making Dashboards Interactive: http://chandoo.org/wp/2012/08/02/making-dashboards-interactive/
• Tips for optimizing performance instructions: http://msdn.microsoft.com/en-us/library/ff726673(v=office.14).aspx
• I Heart IF: http://www.excelhero.com/blog/2010/01/i-heart-if.html
• The Venerable Sumproduct: http://www.excelhero.com/blog/2010/01/the-venerable-sumproduct.html
• The Imposing Index: http://www.excelhero.com/blog/2011/03/the-imposing-index.html

So what do I need to add to this short list? I'm only after the best of the best - so if you can think of 10 awesome things, but 2 are absolute standouts that you would gladly take to a desert island, then I'm more interested in the 2 than the other eight.

 

[Smallman]

Hi Jeff

Sorry I am going to bring the hammer down on this one. I am a bit biased but Dave Hawley created a monster in Ozgid. Not written as a typical blog but rather a how to database of VBA and Excel development. Dave has laid down some of the most useful and well trodden pages on the interweb. Most of the code could now do with an update but if you have both guns flexed you can make his creation fly.

Deb Dalgleish comes in a close second for her simplicity and thoroughly enjoyable style. Her solutions are thought provoking and can also be adapted well to everyday XL problems. I also think the code could use with some updating but the foundations are solid.

Those are the two I would say are standouts for mine and I am taking those puppies with me to the Island.

Good post Jeff.

Smallman

 

[jeffreyweir]

We've been hanging around the same joints. Thanks for reminding me of Ozgrid. This in particular:
Golden Rules of VBA: http://www.ozgrid.com/forum/showthread.php?t=177019
Deb's download page is outstanding. What I need is some outstanding posts from that outstanding collection.

 

[Sajan]

Hi Jeff,
One of my favorite blog posts is the following by Colin Legg:
http://colinlegg.wordpress.com/2012/03/25/binary-searches-with-vlookup/

-Sajan.

 

[jeffreyweir]

That's a great one. Thanks Sajan. Straight to my spreadsheet it goes.

 

[bobhc]

http://www.contextures.com/

http://www.rondebruin.nl/

 

[Hui]

http://chandoo.org/forum/threads/popular-and-useful-forum-posts.10604/

 

[jeffreyweir]

Thanks, Hui. Forgot about that one.

Bobhc...I'm after particular posts from sites if I can get them. Already have a few bookmarked from those, but I'm lazily trying to get you all to help write my blog post for me, for my personal gain and your personal pain

 

[shrivallabha]

These are not really blog posts but forum posts written in similar way [on LOOKUP]
http://www.mrexcel.com/forum/excel-questions/102091-9-9999999-a.html
http://www.mrexcel.com/forum/excel-questions/18954-question-aladin.html
http://www.mrexcel.com/forum/excel-questions/310278-vlookup-multiple-matches-match-returned.html#7)

These I read when I get bored:
http://spreadsheetpage.com/index.php/oddities

 

[lohithsriram]

This helped me to resolve some of my Excel issues and even couple of posts on Chandoo.

Get.Cell() http://www.excelfox.com/forum/f13/excel-macro-functions-get-cell-75/
Get.Document() http://www.excelfox.com/forum/f13/excel-macro-functions-get-document-76/

 

[jeffreyweir]

Thanks all. Keep 'em coming.