Dim Cell As Range

For Each Cell In Selection
Debug.Print Cell
Next Cell


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