using named ranges in macros

assign the value of the named range to a variable, thus:

dim abc as string

abc = sheets("Sheet 1").range("Account").value

where Account is a named range in Sheet 1