Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I just update values on several cells (not the entire works
Hi all,
I have a worksheet contents 1 data sheet and 2 charts on sheet2, and sheet3. On the data sheet, I used a 3rd party add-in to generate some data. A couple cells on that sheet will then be calculated based on the values obtained from the plug-in. I can update everything by hitting F9, but since that updating the data using plug in takes forever, I'd be better off just to click each cell to trig that to update. I am wondering if there is a way (using code) to just update the selected few cells, and the 2 charts but not the rest of the cells in the workbook. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I just update values on several cells (not the entire works
"Jeff" wrote:
On the data sheet, I used a 3rd party add-in to generate some data. A couple cells on that sheet will then be calculated based on the values obtained from the plug-in. I can update everything by hitting F9, but since that updating the data using plug in takes forever, I'd be better off just to click each cell to trig that to update. I am wondering if there is a way (using code) to just update the selected few cells, and the 2 charts but not the rest of the cells in the workbook. So you've got AutoCalculation turned off and you want to recalculate specific cells? Ranges (and Cells, since Cells are Ranges, too) have a Calculate method. One cell at a time: for the cell in row rowindex and column columnindex: Worksheets(sheetname).Cells(rowindex, columnindex).Calculate For a range that includes C12 to C15 and D16 to D19: Worksheets(sheetname).Range("C12:C15,D16:D19").Cal culate When you recalc the cells, the tables should update automatically. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I just update values on several cells (not the entire w
When you recalc the cells, the tables should update automatically.
Charts... the charts should update automatically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to change/update values in range of cells by X% ? | Excel Discussion (Misc queries) | |||
combine 111 in one column & .jpg in another thru out entire works | Excel Worksheet Functions | |||
Linking cells: open source to update values | Excel Discussion (Misc queries) | |||
How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) | |||
How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) |