My workbook has two sheets - one is the actual report and
the other is where the data is kept. The report contains
a grid with times listed in the column and names across
the top. Formulas fill in the grid from the data on the
other sheet. I use ADO to connect to a database, get the
data for the time range, dump the data to the one
worksheet, then the formulas automatically update the
report. TADA! Works fine... EXCEPT....

When the data is copied into the first worksheet, the
formats for the times in the report change. My code does
nothing to change the formats on the report sheet. It
just happens, I assume because the formulas refer to that
other data.

My solution has been to add code to put the formats BACK
where I had them, but it seems pointless to have to do
that.

Does anyone know what I'm talking about and how to fix it?

tod