Heres my new dilema, I have a user with a very complexed ODBC report.

The problem is the are an additional X number of columns added with formulas
based on the contents of the ODBC.

When the ODBC refreshes none of the many columns adjecent copy down along
side only the absolute next column............Does that make sense?

My question is, is there a way programically in VBA to get the worksheet to
copy down ALL the forumlas in ALL the columns after the ODBC has been
refeshed to the point where there is no more data in the rows of the ODBC?

tia

J