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
Configuration: Windows XP Firefox 3.0.1
Hello,
'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 "Pour trouver une solution à ses problèmes, il faut s'en donner la peine." |
"delete row" excel 2 xp os on the same computer delete 1 Any way to restore deleted files after system restore Avoid deleting row excel macro Delete first row from table in microsoft word Delete row if specific column found a particular data Delete virus using command prompt Getting range from row and column number in excel macros How i can to delete win32/conficker.x from vista 64-bit How to check the range of columns against a different row How to delete autorun.inf virus Macro format cell date range Mysql delete row if values duplicate Retrieve deleted email from gmail Select range delete column when cell = Unix vi delete row containing Visual basic delete row Which protocol in its default configuration downloads e-mail messages to the client computer and deletes them from the server?