Hi,

My problem is
I have a workbook which has 10-12 sheets, so i want send only those sheets whose value(i.e name of the sheets) are given by the user in a column say E as an attachment of mail. I have written the macro for sending the sheets, however i am facing the problem in getting the name of the sheets and use them in the array.
If i give the sheet names directly in the as

.Sheets(Array("Sheet1", "Sheet2", "Sheet3").Copy

than its working fine, however i want to use it as
If the user has given the 5 sheets in the column E say from E4 to E7 than i only use those sheets for copying . I tried to use loop however i am not succeed may e i am using it incorrectly

I also tried to directly mention all the names of the sheet in the code like
.Sheets(Array(Sheet2.Cell(4,5).value, Sheet2.Cell(5,5).value,Sheet2.Cell(6,5).value, Sheet2.Cell(7,5).value, etc, etc).Copy

However in this case if in any of the column there is no value say in E5 than i ma getting an error.

So please help me on this.
Thanks in Advance