Continued Cell Formulas Across an ODBC

  • Thread starter Thread starter jonathan
  • Start date Start date
J

jonathan

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
 
-----Original Message-----
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


.
Click to expand...

This should happen automatically - for all your formula
columns - if you have it set up properly. In the ODBC
data range, right click and go to Properties and set the
check box beside "Fill down formulas in columns adjacent
to data" - then (this could be your problem) make sure
there are no blank columns between any of the formula
columns and the data range. Even one blank column will
prevent Excel from copying the formulas.
 
Back
Top