Excel 2007 : Getting The Array Element of a Formula from a Different Cell

[boohah]

Hi

I have a simple formula searching for the smallest number in 5 cell:

=SMALL(A1:A5,1)

What I would like to do is have this formula reference to another 2 cells which will provide the start row and end row number of the array (i.e. the 1 and the 5). That way i could change it to A7:A1000 or A3:A75 for example. If I make B1 and B2 the start row and end row cells, how could i rewrite the above formula to do this.

Doug