in a general module, Range("List") should work in all cases. In a sheet
module, if the list range is not on that sheet
worksheets("Sheet1").Range("List")

--
Regards,
Tom Ogilvy

"Mike" wrote in message
oups.com...
Tom,

Thanks alot indeed. It is working now. Because I have alot of buttons,
in different sheets, that I want to make their names dynamic I have 2
question:

1)Can you say .Range("List") instead of .Rang("c1:c8"); where "List is
a range name?
2)Suppose you are in Sheet2, can you say .Range("Sheet1!List") instead
of .Rang("Sheet1!c1:Sheet1!c8")?

Thanks,
Mike