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

J

jaffar

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.
 
I

Ivan Raiminius

Hi Jaffar,

try something like this:

Sheets("somesheet").Copy
Before:=workbooks("someworkbook").Sheets("someothersheet")

Regards,
Ivan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A simple if <> nn then Msgbox "No Match" 5
Should I be content with the time code takes? 2
Copy columns and paste with blank column between 5
UnSelect the copied to range after copy... 4
Help with condensing a lot of copying/pasting... 4
how to copy an excel sheet with out using paste method 6
I'm Paste values stupid 4
Formatting and copy or copy and formatting ?? 2

Top