I put this formula in a cell: =Address(5, 6, 2) and the cell displays F$5 (row 5, 6th col, absolute row, relative column) as I expect. But when I create the following Sub:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   MsgBox Address(5, 6, 2)
End Sub
and then double click any cell, I get this message displayed: "Compile Error: Sub or Function not defined" with the word Address highlighted.
In searching the web, I found reference to needing to add the Solver reference under Tools/References. When I open Tools/References, I see a list with "Visual Basic For Applications", "Microsoft Excel 16.0 Object Library", "OLE Automation", and "Microsoft Office 16.0 Object Library" checked, and 200 or more items unchecked. But I cannot find "Solver."
All the references I find about using Address show it as ADDRESS. When I enter it in all caps or all lower case, it changes it to initial cap only, so it seems to recognize the word. Am I doing something wrong, or am I missing a library?