Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Formula's
Using CopyFromRecordset, my VB code copies data to "Sheet2" of a
spreadsheet. "Sheet3" contains formula's that utilize the data in "Sheet2". The number of records in "Sheet2" vary (one time there may be 100 and the next time there may be 200). The cells on "Sheet3, row 2" contain the formulas corresponding to "Sheet2, row 2". How can I get VB to copy the "Sheet3's" formula's down from row 2 to the last row corresponding to the block of data in "Sheet2"? Thanks for any suggestions. Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA'S | Excel Discussion (Misc queries) | |||
formula's | Excel Discussion (Misc queries) | |||
formula's | Excel Discussion (Misc queries) | |||
IF formula's | Excel Discussion (Misc queries) | |||
how do i copy a formula's result to another cell, without copying. | Excel Worksheet Functions |