Hi,

Is there a way that using vba, i would like to copy the
particular cell range from worksheet1 and paste into the
new workbook? Also, how to ensure that the particular
cell range that i copy will contains text instead of
empty cell?

many thanks.

regards,
Ven