Hello,
I am a VB Novice and need help.

My code allows the creation and naming of worksheets
according to user input into a list. If the user updates
or adds to the list, I want the worksheets to be deleted
and replaced with the updated versions, by using only a
single menu item.

Because of the user input, I cannot specify a fixed array
of sheet names. How can I specify an array that depends
on the user input? (The list of sheet names specified by
the user is a named range, but the array command did not
work.)

I tried: Sheets(array(range("User_List"))).delete
I also tried: Sheets(array("User_List")).delete


Thanks!
LJones