How do you get the value, row number, column number and address of a cell using name in VBA?

Here is how…

We have a cell G11 named as “_Tag_Marker_Cell”. See screenshot below.

Xybernetics Excel VBA - Cell By Name

The VBA code looks like that and the respective results is on the right side of the instructions (as comments)

Xybernetics Excel VBA - Cell By Name

Happy VBA-ing… if that is even a word.

n1849778
About the
I am a software developer in Calgary, Alberta, Canada with passion in getting my fingers in any new technology. I started software development when I was 10 years old and have never looked back. Now with well over 35 years of software development, I wanted to share some of these key knowledge with the people of the world in the wide web.