Thread: [SOLVED] Copy/Paste Special Values From One Workbook To Another

Hey guys, I have this code that I am using that works perfectly, except I wanted it to paste values only, and since I got this code from someone on this forum and I don't really understand it, I was hoping someone might be able to tell me what to do...

Code:

With Workbooks("WC2009_RunningSheet.xls").Worksheets("FTH")
        Range(ActiveCell, "BR2").Copy _
        Destination:=.Cells(.Rows.Count, "A").End(xlUp)(2)
    End With

Any ideas?

Try this:

Code:

Range(ActiveCell, "BR2").Copy 
Workbooks("WC2009_RunningSheet.xls").Worksheets("FTH").Cells(Rows.Count, "A").End(xlUp).Offset(2, 0).PasteSpecial xlPasteValues

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and add the word [SOLVED] to the beginning of the title.

Glad it worked out for you.