Using a range of column names

[AlexanderBB]

If I set a range to a row in my Worksheet I can refer to each column by it's index number.
But what If I'd like to use column names instead?
My thinking is too add a class module but then I'd have to populate it by the range and there'd be no advantage. Is there a better way ?

 

[StephenCrump]

The question is not totally clear, but could you use something like:

Set r = Rows(5)
MsgBox r.Cells(1, "AA").Address

 

[AlexanderBB]

I'll give an example
Row 1 Col "I" is "Artist"
Private Sub Worksheet_SelectionChange(ByVal Target As Range
Set iRange = Range("A" & Target.Row & ":Z" & Target.Row)
end Sub
? Range(5) ... will show the current row, column "I".
But instead of range(5) I want to be able to use myRange,Artist.

 

[StephenCrump]

iRange(5) will show current row, column E.

Artist = "I"
x = iRange.Cells(1, Artist)

will populate x with the value of current row, column I.

(But note that the "I" reference here is relative. It will get the 9th column in iRange, which is I only if iRange starts in column A)