Hello all,
I am exporting data from Access 2002 to Excel. Unfortunately, I am
exporting a sub report that produces blank cells in columns A thru M for the
sub report data. For example my ONE relationship of Customer is on row 1.
The many relationship ORDERS is on rows 2 thru 5, but the data on rows 2 thru
5 doesn't start until column N.
I have put this bit of code together that seems to work for Row 1.

How can I modify it to cycle thru all of the rows with data?

If a1 = "" Then
Range("b1:M1").Select
Selection.Delete Shift:=xlToLeft
Range("a1:a1").Select
End If

Is there also a way to pass this code/macro from Access to the new Excel doc
the users are creating from Access? Or get this code to execute after Access
has completed the export of data to the excel document?

Any assistance you can provide is greatly appreciated.