I have a macro which uses MSQuery in an Excel sheet.

There are 2 types of queries possible, and it is possible that the query would fail to retrieve any information.

Both query returns records consisting of 6 columns.

Sometimes i get the following error:

To prevent loss of data, Microsoft Excel cannont shift nonblank sheets off the worksheet.

And i notice that the sheet with the query on it is now reduced to 2 columns.

However, in the next query, it does not repopulate the w/ all 6 columns, but just thetwo.

do you know of a way to stop this ?