MACRO QUESTION IN EXCEL

[kentwoodjean]

I have several Crystal reports on our intranet site that I currently download into Excel. I then export the report into Access and use the data for specific reports we have designed. Unfortunately, each report has about 8 lines initially that consume the header field. Currently my macro eliminates those lines. There are however, several "blank" lines between sections of data that I also must eliminate for proper formating in Access. Because where these blank lines are position on the excel spread sheet can vary, I remove each one separately outside of the MACRO.

Is there anyway to define the MACRO to not only remove the header field, but also blank lines "where ever" they are located. I.e telling the MACRO to remove 2 liness between each section?? If so, how would it read?

 

[Dreamboat]

If there is ever ONE column that ALWAYS contains a blank cell when the entire lines are blank, then you can record this and incorporate it into your macro:

Select the column.
Choose Edit-Go to-Special, Blanks, OK.
Edit Delete.
When asked which delete option, choose Entire Row. Anne Troy

http://www.TheOfficeExperts.com