Use a defined name in your macro

I want my VBA macro to refer to a name I defined in a worksheet within the current workbook:

Define VBANAME as the value of a cell you have named NAME

Application.GoTo Reference:="NAME"
VBANAME = ActiveCell.Value

Define VBAROW as the row of a cell you have named NAME

Application.GoTo Reference:="NAME"
VBAROW = ActiveCell.Row

Define VBACOL as the column of a cell you have named NAME

Application.GoTo Reference:="NAME"
VBACOL = ActiveCell.Column