The site formerly known as Code For Excel and Outlook
August 24, 2010 by · 
In Add Data Validation to any worksheet using VBA I demonstrated a technique for … adding data validation to any range. Surprise! 
Now we'll try and do something with those data validation ranges. What I'd like to do is select a cell that has data validation on it and return the list of valid members (assuming that the source data is a Range or name that refers to a Range).
Continue Reading: Get Data Validation Range »
January 22, 2010 by · 
In Return value if in range in excel, Oscar shows us a formula for returning values in a column based on a number range. Let's review his formula and also provide a few more that can do the same thing simpler.
Continue Reading: Getting an approximate match from a range »
March 1, 2009 by · In the NETWORKDAYS example in one of my previous tutorial posts, 'HolidaysList' refers to a static range: A6:A15.
Many ranges are static, that is, they consist of a finite amount of data that isn't likely to change.
Continue Reading: Excel Tutorial Series – Range Operations »
November 13, 2008 by · (See my followup post Export Excel Range to a Picture File, Redux for updated VBA.)
If you ever needed to capture a range, for pasting into a document or email, you'll need to save it as an image first. If so, you might find this routine useful. It takes a contiguous range, starting in A1, and creates a GIF file with a snapshot of the range.
Continue Reading: Export Excel Range to a Picture File »
Site last updated: February 8, 2012
Follow Me