Sub demo()
MsgBox (Range("happy").Parent.Name)
End Sub

--
Gary''s Student - gsnu200732


"Zone" wrote:

I have a workbook with several worksheets. Each worksheet has many
named ranges (single-cell ranges, all in row 1). I want to specify a
range name and have my subroutine activate the sheet containing the
range name and select the column containing the range name.
Thanks, James