I have a vba program that, among other things, gets data from an
oracle db using ADO. I am trying to use copyFromRecorset to paste the
data into a worksheet. Everything appears to work fine (ie the data
is pasted correctly and no errors are visible). When the program is
finished and I try to add another sheet however, column A is formatted
with some unrequested combination of fill and pattern. My
program/application has been working fine for months (using oo4o to
connect to oracle) I need to change to ADO for improved performance
with the specific query used by the application and I am hoping to use
CopyFromRecordset again for improved performance. I believe I have
isolated this problem to this line (when this line is not in the
program the strange behavior does not occur).

Any help would be appreciated.

Mary