Sorry, I previously posted this to the wrong forum.
Is it possible to specify a cell by it's alias? I do not mean the column letter concatinated with the row letter, ie. "K3". I would like to specify the cell by the alias that has been assigned to the cell in the Name Box.
For example instead of
cells("K3").PutValue(150)
I would like to use
cells("GreenHigh1").PutValue(150)
"GreenHigh1" is the alias that I assigned to the cell "K3" by typing in the Excel Name Box.
Thanks