Referencing Cells in a Selected Row

[Guest]

I need to obtain the value in several cells from a row selected by the user.
What is the syntax that I should use to pull the values from the selected
row?

Dim sel As Range
Set sel = Application.Selection
sel.Cells(sel.row,1)

 

[Guest]

Dim Cell As Range

For Each Cell In Selection
Debug.Print Cell
Next Cell

 

[Guest]

....or if you know what columns you are looking for:

MyValue = Cells(Selection.Row, 1)

etc.

 

[Guest]

Found the problem, I was thinking that the row number in the worksheet would
correspond to the row number in the selection which it does not. Since I
limited the number of rows that can be selected using sel.rows.count to
reference a cell the syntax would be sel.cells(1, [cell number])