0

I have 10 Excel files with around 50 sheets in one particular folder which I need to remove the first rows. Could you please suggest VBA code for doing this?

Thanks in advance!

Below is my code to delete the first row.

Sub DeleteFirstRow()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
     ws.Range("1:1").Delete
    Next ws
End Sub
Junie
  • 1
  • 2
  • Welcome to SO. Please read [ask] If you search on SO, there are a lot of solutions for this, e.g. https://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba – Ike Oct 05 '21 at 09:52

0 Answers0