Assign a name to a spreadsheet range (type into the name box). menu:Insert>Names>Define...[Ctrl+F3] Select the new name and remove all $ from the reference. Hit the "Modify" button.
*** This bug has been marked as a duplicate of bug 40571 ***