Delete blank rows

[dhivya.enjoy]

Hi

Add these lines before you save the workbook as CSV.

On Error Resume Next
wbkNew.Sheets(1).Columns(1).SpecialCells(4).EntireRow.Delete
On Error GoTo 0

Hi,

This will not delete my blank rows in first row right? i want them as blank only since my first rwo of csv will hold table name. and second row will have all column name and 3rd row will have data.

Regards
Dhivya