Hi everyone, I need help with a couple things.

I need ot move data from a sheet in a spreadsheet to a new sheet int he
same spreadsheet.

Is there a way to set an Excel.Worksheet object by name of the sheet
and not the index?

i.e. instead of doing set xlSheet = xlBook.Worksheets(1), I have the
name of the Sheet.

Secondly, how do I copy from one sheet to another?
Worksheets.FillAcrossSheets? Can anyone point to a good online sample?

Thanks in advance for the help,
Cen