Questions are best posted to the newsgroup.  I just noticed 
this in the newsgroup yesterday using RANGE, so before the
weekend I would not have known.  Anyway this this test
illustrates.  3.1416 is good enough for rocket science but
why not use the builtin function.

Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   'with named cell PI having value of 3.1416
   ' of course there is a  PI()  function with a more correct value
   Cancel = True   'Get out of edit mode 
   MsgBox Range("pi").Value & " ^ 2 = " & Range("pi").Value ^ 2 _
     & Chr(10) & "value of Application.PI() as in here:  " & Application.Pi() _
     & Chr(10) & "squared seen as " & Application.Pi() ^ 2

   ActiveCell.Offset(0, 1).Activate 'get out of cell input mode

End Sub