I have a list of names stored in a worksheet and I want to use these to
define a set of variables.

I there anyway to do this

I tried this

Dim Sheets("names").Cells(1,1).Value As String

but with no luck

Ian B