I have this macro but I want to edit several sheets within the code and so it is telling me to modify the code for each. Is there a simple code that I can write per spreadsheet this edits within the macro to delete any rows that are empty data? Below is the one I am currently using.
VBA Code:
Dim LastRowIndex As Integer
Dim RowIndex As Integer
Dim UsedRng As Range
Set UsedRng = ActiveSheet.UsedRange
LastRowIndex = UsedRng.Row - 1 + UsedRng.Rows.Count
Application.ScreenUpdating = False
For RowIndex = LastRowIndex To 1 Step -1
If Application.CountA(Rows(RowIndex)) = 0 Then
Rows(RowIndex).Delete
End If
Next RowIndex
Application.ScreenUpdating = True