Use

=OFFSET(Htestc!BINFilStart,0,0,COUNTA(BINFilStart: $A$133),1)

excel adds the sheetname as the range could be referred to from another
sheet.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
I have a Named Formula:
=OFFSET(Htestc!BINFilStart,0,0,COUNTA(BINFilStart: A133),1)
once the formula is entered as a name the it changes to:
=OFFSET(Htestc!BINFilStart,0,0,COUNTA(Htestc!BINFi lStart:Htestc!IV132),1)

"something" adds the sheet name, Htestc, to all references which doesnt
hurt but also the reference A133 gets change to some random value, in
this case "IV132"

what causes this, or more importantly, what should I do about it.
Thanks
Robert