TechTalk - Excel VBA : Cell By Name

TechTalk - Excel VBA : Cell By Name

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.