Thanks watersev,
I am using now a nextrow for an expandable list and I am getting the error 438. I am not used to this code.
What do think is the correct structure?![]()
Set nextrow = Sheets("DataOld").Cells(Rows.Count, 3).End(xlUp).Offset(1, 0) If Not DelR Is Nothing Then DelR.EntireRow.Copy Sheets.Add.nextrow <--- here is the error DelR.EntireRow.delete End If
Thanks
Bookmarks