VBA Code is slow-reason ???

[adr12345]

Hi,

I am using similar lines of codes to add more than 50 lines to the existing data.

Cells(P,Application.WorksheetFunction.Match(Workbooks("Reference").Sheets("Carrierlist").Range("A"& i) "ARC", Rows(1), 0))


Result is my code becomes slow.

Would assiging this code a variable solve my problem of code being slow ?

 

[diddi]

worksheetfunctions are notoriously slow.
if you are using vba anyway, try constructing an index and storing it as an array thus avoiding working with cells on sheets

 

[adr12345]

Can you suggest any thing on those lines of code which I have used ?