Cycle through cells as filenames

[Dendennydenden]

Hi,

I hope someone can help with this.
i am trying to use VBA to import data from multiple csv files.
Column A contains a list of filenames (around 20 rows)
My current code goes to cell A3, uses that as its filename, copies information from the file and pastes it into cells B3:M3 of my 'master'.

Can someone advise me on how to then move down a row, repeat the copy/paste macro, and continue down until it finds a blank row in column A.

All help gratefully received.

Thanks

 

[Peter_SSs]

Looks like a structure like this should do what you want

Sub Process_Files()
  Dim fName As String
  Dim r As Long
  
  r = 3
  Do Until Len(Range("A" & r).Value) = 0
    fName = Range("A" & r).Value
    r = r + 1
    
    'Your existing code goes here, using the variable fName as the file name
  
  Loop
End Sub