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")...