Rookeby7

New Member
Joined
Jul 5, 2019
Messages
18
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


Code:
        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]
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,807
Office Version
  1. 365
Platform
  1. Windows
Re: rCopy...paste vlaues??

Just replace the word Formula with Value
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,807
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,118,662
Messages
5,573,480
Members
412,533
Latest member
Pejter
Top