i have question on how to get rid of hidden or blank lines when you export to Excel from crystal report?

i am using crystal reports 8.5 with visual basic 6.0