how to copy an excel sheet with out using paste metod.
 

Hi,

I have a macro , using this macro i can copy an excel sheet into
another excel sheet, but i used paste method ( pastespecial
paste:=xlpastevalues),

I want the same functionality with out using paste method,

How can i do this task?

Thanks in advance
Jaffar.

how to copy an excel sheet with out using paste metod.
 

Hi Jaffar,

try something like this:

Sheets("somesheet").Copy
Befo=workbooks("someworkbook").Sheets("someothe rsheet")

Regards,
Ivan