Using Offset to name a range
 

I have a worksheet that filters data to
b17 through k(row number will vary)
can someone tell me what is wrong with this function?
I admit i have a rough time with offset!
=OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.!$2:$2))

Thank you-Jennifer
--
Though daily learning, I LOVE EXCEL!
Jennifer

Hi Jennifer,


=OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.!
$2:$2))

write the count-formlas in cells and check the result they give. are
they doing what you want?

arno

When i test it selects column b:c and etends about 8 rows past the pt. of data.
--
Though daily learning, I LOVE EXCEL!
Jennifer


"Jennifer" wrote:

I have a worksheet that filters data to
b17 through k(row number will vary)
can someone tell me what is wrong with this function?
I admit i have a rough time with offset!
=OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.!$2:$2))

Thank you-Jennifer
--
Though daily learning, I LOVE EXCEL!
Jennifer

Jennifer,

This seems to work for me

=OFFSET('GwrStmts '!$B$17,0,0,COUNTA('GwrStmts '!$B:$B,1),COUNTA('GwrStmts
'!$2:$2))

If the sheet really does have a trailing space in the name, you need
apostrophes
--
HTH

Bob Phillips

"Jennifer" wrote in message
...
I have a worksheet that filters data to
b17 through k(row number will vary)
can someone tell me what is wrong with this function?
I admit i have a rough time with offset!

=OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.!$2:$2
))

Thank you-Jennifer
--
Though daily learning, I LOVE EXCEL!
Jennifer