database query problem

[alshar]

I have a database query set up on an excel sheet. The query returns 3 columns of data. To the right of the 3 colums I have formulas that manipulate the data that is returned from the query. I have a button set up to refresh the query.

Here is my problem:

When I refresh the query and it returns less rows than a previous refresh, it will insert cells that say "#REF!" before the last record. The formulas to the right of the error cells also say "#REF!". I cannot for the life of me figure out why this is happenning.

[HiArt]

Hum, interesting.

This might be dirty data in your objects.

Make sure that the code to populate the worksheet closes both the recordset and the database objects. E.g.

myRecordSet.Close
myDBS.Close

When walking the recordset, make sure you initialise the pointer with myrecordset.MoveFirst

HTH

Art