Spy Journal 3.0 Filtering the web for you

Check out Sports Do, it's a GPS sports tracking system from your mobile phone for friends and family. It enables you to record your sporting activities while broadcasting live tracking stats to friends and family via the SportsDo web portal. A detailed analysis of your activities can be performed on the SportsDo web portal so that you can improve your performance. Check out SportsDos website for more info.

Andrew recently posted a piece of VBA code used to create dynamic ranges. Very useful.
Here is my original post on dynamic ranges posted back in 2004 repeated.
If you have used a range name before then you will know that it can be frustrating updating the reference of the range name if you want to add data to the range.
Here are some ways you can dynamically update the range by using the OFFSET function in the range name reference.
Assume for all these examples that column A has a mixture of text and numbers for several cells.
Click Insert - Name - Define on the menu.
In the Names in Workbook Dialog box type a range name (Eg test_range) and then try these different options.
1: Expand Down as Many Rows as There are Numeric Entries.
In the Refers to box type: =OFFSET($A$1,0,0,COUNT($A:$A),1)
2: Expand Down as Many Rows as There are Numeric and Text Entries.
In the Refers to box type: =OFFSET($A$1,0,0,COUNTA($A:$A),1)

We just finished playing a boisterous game of hide and seek - lots of fun and a real challenge to find the places the kids can't find me. Hiding in plain sight is often the best way.

I had a dream about making scones last night with meat in them. While thats a bit weird, I can make really good scones - in fact I have even won prizes for them.

So I thought I would give the recipe I use and the creative combinations of "special" ingredients that make them good.

Scones follow a basic recipe that has the same proportions of things. I'm using 3 of everything below, but you could use 1 or 2 or 5 if you wanted.

 

Start with a large enough mixing bowl for how much you are going to make.