Is there a shorter / more direct way to do this?
VB Code:
  1. Sub TestSub()
  2.    'TestCell is the name of a specific
  3.    'cell containing input data
  4.     x = ThisWorkbook.Names("TestCell")
  5.     y = Range(x).Value
  6.     Cells(12,9).Value = y*y
  7. End Sub