Have you tried using the macro recorder to get an idea of how it's done?

--
Don Guillett
SalesAid Software

wrote in message
ps.com...
I am hoping someone can help me. I am new at this VBA stuff so
hopefully I can get some help. I am trying to write a macro that will
allow me to copy one specific worksheet from a workbook that is opened
and paste it to another different workbook that is also already open.