I know that when referring to the text in a cell in excel I would write something like
INDIRECT(".....") etc
But if i have a cell with a name in it, and want excel to always copy the text in the cell, how do i write that in vba
e.g
Application.Goto Reference:=xxxxxx
cheers
INDIRECT(".....") etc
But if i have a cell with a name in it, and want excel to always copy the text in the cell, how do i write that in vba
e.g
Application.Goto Reference:=xxxxxx
cheers