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])

"dch3" wrote:

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)