Jens

Hi Wasay,

Thank you for the forum question.

In the workbook please press ALT F11 to open the Visual Basic Editor. In the project explorer (Left top box) right click on the workbook containing the date and click INSERT Module.

In the new module type:

Sub removeUnWantedRows()

Columns(1).Cells.SpecialCells(xlCellTypeConstants, xlTextValues).EntireRow.Delete

End Sub

Make sure that the sheet with the data is the active sheet before you run the macro.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector