delete row in a range Closed

Question

Hello,
I copy a range from sheet1, workbook1 to workbook2, sheet2, after the last row, that means the range from workbook2, sheet2, is each time in another place. I want to delete empty rows from the range that reside in workbook2, sheet2. How should I do that?

  Thanx very much

jamesyap34 · Answer

hello,

couldnt you select the fields and just press on delete on your keyboard?

aquarelle · Answer

Hello,
Maybe, you can adapt this macro : 
'To delete empty rows in active worksheet

Sub DeleteEmptyRow()
LastRow = ActiveSheet.UsedRange.Rows.Count
Application.ScreenUpdating = False
For x = LastRow To 1 Step -1
      If Application.CountA(Rows(x)) = 0 Then Rows(x).Delete
Next x
End Sub

Best regards

Delete row in a range

2 responses

Similar discussions

Subscribe To Our Newsletter!