Skip empty row and fetch values from other rows

[dhivya.enjoy]

Hi Team,

My excel will have number of columns and rows with values.There will be one row space between each row of data. When i run my macro a csv file will be generated. In this case my macro should skip the empty row and then check the next row where values are available.

In my excel column A and Column B must have values excluding the empty rows.

Kindly give me a code for this

Regards
Dhivya

[patel]

can you attach a sample file with desired result (your macro included) ?