VBA- Delete rows and maintain data of one specific column

[Dancarro]

Hi,

I need your help in relation to Excel 2010.

In one of my worksheet I have data entered in A1:F200 and some rows are blank.

I want to show only the information of the respective rows which contains information in column F, and to delete all the remaining rows and to go the next row where information is located in column F.

For example: A B C D E F
1 _x______x____x______________ x
2 ________x____x__________x ___x
3 ________x____x________________
4 ______________________________
5__x__________________________x
6 _ x_____x_____________________
7 _________________ x____x____x

x= data inserted in the cell


Referring to the above example, what I need to show is the following:
Row 1: This row to stay, as it has information in cell F1.
Row 2: This row to stay as it has information in cell F2.
Row 3: Can be deleted - No information in F3.
Row 4: No information and to be deleted.
Row 5: This row to stay, as it has information in cell F5.

I would appreciate your help regarding my problem and if there is a VBA code to assist me.

Kind Regards,
Daniel

 

[Michael M]

Try

Sub MM1()
Dim r As Long
For r = 200 To 1 Step -1
    If Range("F" & r).Value = "" Then Rows(r).Delete
Next r
End Sub

 

[Dancarro]

Hi Michael,The code works perfect.Thank you very much, Michael.Kind Regards,Daniel