Forum Discussion
Changing range references in Name Manager
I am getting a strange result in Excel Names Manager. I want to set up 6 Named Ranges with each having some version of this formula: =OFFSET(Assignments!I3, 0,0,COUNT(Assignments!H:H),1) which shou...
Bob_Martin , most probably you need to lock you references, use $ sign for that, like
=OFFSET(Assignments!$I$3, 0,0,COUNT(Assignments!$H:$H),1)