Jordan Goldmeier, Author at Excel TV - Page 11 of 11

All posts by Jordan Goldmeier

Completing the Square aka The "Most" Squares Method

Now that I actually have some traffic to this blog, it’s probably time I started adding posts. A while ago, I was wondering how to make the cells in Excel exactly square, like the squares on graph paper.  I came across this post from Mr. Excel.  I wasn’t in love with his solution because it […]

Continue reading

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

“Rollover B8 OV1” (like Rollover Beethoven…? get it?)Update 17 July 2011: This blog entry was featured in Chandoo’s latest post. So if you’re coming here from his site — welcome! original post: This post was inspired by Chandoo’s post on hyperlinks in Excel. If you haven’t checked his website out yet – you should. It’s […]

Continue reading

Getting a Handle on hWnd

Sometimes, you’ll want to programmatically take advantage of Windows outside the capabilities readily available through Visual Basic for Applications (VBA). For example, both eliminating the “Close”-button or creating a more opaque background on a window require the use of the Windows API. Doing this in Visual Basic isn’t too hard, but there are some distinct […]

Continue reading

A High Ranking Function

Excel really doesn’t have an explicit “between function” to allow users, given a set of ranges, to find in what range a selected number falls. The obvious and messy workaround is to use a bunch of nested IFs, which is tedious and error-prone. That’s where the RANK function comes in. Here’s a breakdown. RANK(number,ref,[order])number – […]

Continue reading
1 9 10 11