Share your favourite posts

[Lewiy]

There always has to be someone who comes up with a better way of doing things!!

 

[Jon von der Heyden]

Wow, this has attracted some great responses.

I also frequently refer to Aladin's posts on dependent data validation. This is something I use almost daily since our reporting is compiled according to a complex organisation hierarchy.

I know I have already listed my favourite 5, but another I use regularly in my work is adding values up from every nth row. See here .
This was my introduction to MOD()...

Regards
Jon

 

[Krishnakumar]

One of my favourites bosco's contribution on EVALUATE

 

[daniels012]

This link was a very interesting one that I use every once in awhile. It passes an image using a formula.
Kady added a very interesting twist to make this work:
http://www.mrexcel.com/board2/viewtopic.php?t=85068&postdays=0&postorder=asc&&start=20

Michael

 

[hatman]

New addition to my Favorites list is this gem where both BrianB and Rigt_Click discuss SendKeys methods (API's versus the VBA Function). Still waiting to see who else weighs in on this topic... but even if the thread ends here, it's a HUGE resource for several approaches to sending keystrokes/messages to other applications.

Huh, I guess Tom, gets 2 for 2 with this other thread that I have had occassion to use often enough that I have actually printed out the code, annotated it, appended several pages of my own commentary and variations, and filed in my cabinet.