consider the following example:

i need to get excel to create a dynamic range based that can determine
the number of consecutive rows in the below array (e.g. 18) , the
number of rows may change (increase/decrease). once that range is
determined i need a function that can create a dyamic range based on
some criteria (in this example, 'days'). in colume E i'm able to find
the unique days from column A. so, if there were some way to find all
the ranges associated w/each 'day' that would be ideal. for example,
if i were to chose the# 12 from column E, some function would return
back the array, B1:B5, or if i were to chose# 25 in column E, it would
return B6:B11. I tried to do this with COUNT and create a string
B6:B11, but was unable to pass it to the function I was using. if
there is any way to do this in VBA, any tips would be greatly
appreciated.


column A column B column C column E
days strike volatility unique
row 1 12 1360 29.54585 12
row 2 12 1365 29.3065 25
row 3 12 1370 29.25345 56
row 4 12 1375 28.30915
row 5 12 1380 28.10265
row 6 25 1385 27.44215
row 7 25 1390 26.15555
row 8 25 1395 26.32795
row 9 25 1400 26.26365
row 10 25 1405 26.8148
row 11 25 1410 25.50125
row 12 56 1415 24.5996
row 13 56 1420 24.796
row 14 56 1425 24.0346
row 15 56 1430 23.5268
row 16 56 1435 22.87455
row 17 56 1440 22.8891
row 18 56 1445 22.1542