| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
