what code to copy from one sheet to another with values only

[scottatbuckman]

I have the below line of code. What can I add to it, to make it only copy values, not formulas?

thanks

Please Login or Register  to view this content.

[ANDREAAS]

[code selection.pastespecial paste:=xlpastevalues, operation:=xlnone, skipblanks _
:=false, transpose:=false
application.cutcopymode = false]Please Login or Register to view this content.[/code]

hope this helps.....

[ANDREAAS]

oops
i was trying to do this.....

Please Login or Register  to view this content.

[scottatbuckman]

How exactly should it go? I put that code under my initial code, and it copyed over, but then gave an error.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[scottatbuckman]

Im sorry, I also need format. Value and Format. I didn't think about that part

[ANDREAAS]

Please Login or Register  to view this content.

hope this helps

[ANDREAAS]

thanks John

feltlike the blind leading the blind there for a second

i'm also a vba novice - too eager to help with my limited knowledge!

[scottatbuckman]

How do I add format with the value?

[scottatbuckman]

This is actually my code.

Please Login or Register  to view this content.

I just want to change the part

Please Login or Register  to view this content.

to only copy the value and format. So as you can see, its pulling the date and making it the new tab name also. Im sorry that I was not very clear before.

[scottatbuckman]

Bump bump...

[scottatbuckman]

anyone know?