Figured out that I had to move
into the For loop,![]()
Set wbNew = Workbooks.Add 'adds blank workbook wb.Activate
addand replace![]()
Dim ws As Excel.Worksheet
with![]()
wb.ActiveSheet.Rows(r).Copy wbNew.Sheets(1).Rows(1)
![]()
ws.Rows(r).Copy wbNew.Sheets(1).Rows(1)
Bookmarks