Well .. that worked supremely ... but I asked the question wrong!

I want to move it to another workbook that is open behind the active one ...
how would I do that. My failure to ask the correct question ... I want to
copy the spreadsheet in the active workbook to the last position in the
second workbook which is open behind the first. (I hope that makes sense).


"Bob Phillips" wrote in message
...

ActiveSheet.copy
after:=ActiveWorkbook.Worksheets(ActiveWorkbook.Wo rksheets.Count)
.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Annette" wrote in message
...
I am getting myself confused on how to do this, so I am asking instead.
How
do I programmically copy the active spreadsheet (sheet1) to the open
workbook ... into the last position on the workbook?