I am really the newest newbie in VBA with hardly any knowledge of the terminologies.
This is a very simple problem I have
I have to delete the entire row if "." doesnt exist in Column B.
Also please let me know how to activate a sheet if its name is something else than Sheet1 such that i can generalize it for all the excel sheets i have and add sheets thereafter!
The final product should be directly pasted in sheet 2!
[VBA]Sub Delete()
Dim i As Integer, LastRow As Long
Worksheets("Sheet1").Activate
LastRow = ActiveSheet.UsedRange.Rows.Count
Application.ScreenUpdating = False
For i = 1 To LastRow
If IsEmpty(Cells(i, 2)) Then
Rows(i).Select
Selection.Delete Shift:=xlUp
End If
Next i
End Sub[/VBA]
This is what i ran for deleting empty rows!