Created by Bob Umlas and David Hager
To define a global range name in Excel, go to Insert, Name, Define and, as an example, in the Names in Workbook box type “cellA1? and in the RefersTo box type this formula: =OFFSET(!$A$1,,,,).
Now, type =cellA1 in a cell on any worksheet in the workbook and it will return the value in A1 for that worksheet.
Editors note: And all this time I’ve been setting up PrevCell for each sheet in the workbook. What a chump I am.
Based on that, it appears that you don’t need the OFFSET function. You can define the name cellA1 as