Hi,

give a name to Sheet1!$A$1 like "myStart", give a name to Sheet1!$A:$A
like "myData". Then define a range "myNamedData" with the formula (in
menu Insert/Name/Define write in "refers to")

=offset(mystart, 0, 0, counta(mydata), 1)

if you want colum B to represent "myNamedData" then you have to adjust
your formula to

=offset(mystart, 0, 1, counta(mydata), 1)

I do not see a problem with this if you are moving around your colum A
(mystart and mydata) within the workbook, just make sure you move the
whole range.

regards

arno


"FinChase" schrieb im Newsbeitrag
...
I need a way to determine a dynamic range in order to reference it in
a
formula. The range I need to reference is in column B but the
beginning row
will change each time and the length of the range will also vary. I
tried
using an offset formula I found on the Contextures web site,
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1) but I could not make
it work,
perhaps because the starting row (and the name of the worksheet) will
vary.
Can anyone help?