Copy from recordset only copys to a contiguous area.

--
Regards,
Tom Ogilvy


"Ernst Guckel" wrote in message
...
Hello,

I have a named range 'DayRange' that I am trying to use the
copyfromrecordset method to move data to a worksheet. The problem is that
the data contains 35 fields and the named range contains 35 cells but the
named range's cells are not continuous. Apparently the copyfromrecordset
method copys the data starting at the first cell in the range and from
there
on. It this the case? Is there anyway around this?

Any Ideas would be great,

Ernst.