What is the new start cell? That should be your first argument in the OFFSET
formula.

Adjust the second argument to get the correct number of rows offset starting
in your start cell.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Arlen" wrote:

I have a range called Labels1 that used to expand from A2 to A whatever.
Now, I have to change its functionality so that both the START and END can
change.

The old formula is this.
=OFFSET(Data!$A$2,1,0,COUNTIF(Data!$A:$A,"0"),1)
How do I change it so that $A$2 changes to a new start cell?

Thanks for your help.

Arlen