Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continued Cell Formulas Across an ODBC
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continued Cell Formulas Across an ODBC
-----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 . 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variations on referencing a cell in another workbook - continued | Excel Discussion (Misc queries) | |||
Problem writing Excel formulas via ODBC | Excel Worksheet Functions | |||
Problem writing Excel formulas via ODBC | Excel Discussion (Misc queries) | |||
Cell to Show "Continued" only if > Page 1 | Excel Worksheet Functions | |||
Cell Formatting - Continued | Excel Programming |