and as usual as soon as i post i look at the help for Offset.....

=OFFSET($C$8,0,0,COUNTA($C:$C),COUNTA($C:$AF))
gives you both height and width



"Gixxer_J_97" wrote:

I am trying to create a dynamic range.

so far i have had luck with the suggestion form another user to use:

=OFFSET($C$8,0,0,COUNTA($C:$C),1)

that works when the range is in one column.

what do i change if i want to expand the range to say, AF?

I have tried

=OFFSET($C$8:$AF$8,0,0,COUNTA($C:$C),1)
and
=OFFSET($C$8,0,0,COUNTA($C:$AF),1)

but neither seemed to work. what am i missing?

thanks!