var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Shifting MSQuery in Excel Macro
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 ?