View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] robert.hatcher@l-3com.com is offline
external usenet poster
 
Posts: 55
Default Named Formula reference problem

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