rCopy...paste values

[Rookeby7]

I am trying to copy row 2 from a number of files in to a list

I have used this code, which pastes "formula". can it be changed to "paste, then paste values"?

Thanks in advance

        With Workbooks.Open(sFolder & sFile)
            Set rCopy = .Sheets("TF ROC").Rows("2:2")
            wsDest.Cells(lRow, "A").Resize(rCopy.Rows.Count, rCopy.Columns.Count).Formula = rCopy.Formula
[End code]

 

[Fluff]

Re: rCopy...paste vlaues??

Just replace the word Formula with Value

 

[Rookeby7]

oh wow, I like easy answers like this, many thanks

 

[Fluff]

You're welcome & thanks for the feedback