Hi,

maybe you should retrieve your data using ADO instead:
http://support.microsoft.com/default...b;EN-US;246335

arno

Adding a breakpoint to VBA code and using F8 to step through the code
produces desired results. Without the breakpoint the program fails. I
traced the problem to a worksheet which is not filled in from an SQL query
earlier in the code... the worksheet displays "External Data_1: getting
data..." instead of having valid data from a query.