Hello All,
I hope you can help me with my question and perhaps provide me with an alternative solution.
I am copying the summary page from 60 different files into separate tabs in a new workbook. The formula below works fine for all files except one that contains a large amount of text in one of the cells that needs to be copied. I am copying the range "B1:N190", but in this specific file. The macro stops copying att Cell "K51". I have noticed that cell "L51" contains a lot of data, Len(L51) = 929. and I am assuming that this is why the macro stops.
Is there a way of getting around this issue?
Thanks again
I hope you can help me with my question and perhaps provide me with an alternative solution.
I am copying the summary page from 60 different files into separate tabs in a new workbook. The formula below works fine for all files except one that contains a large amount of text in one of the cells that needs to be copied. I am copying the range "B1:N190", but in this specific file. The macro stops copying att Cell "K51". I have noticed that cell "L51" contains a lot of data, Len(L51) = 929. and I am assuming that this is why the macro stops.
Is there a way of getting around this issue?
Thanks again
Code:
For Each sht In wbSummary.Worksheets
If wbSupportFile.Sheets("Summary").Range("B1").Value = sht.Name Then
sht.Range("B1:N190").Value = wbSupportFile.Sheets("Summary").Range("B1:N190").Value
End If
Next
