Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi All,
I am not sure if this is the right forum for a VBA question, but I did not find a more suitable one. I have a large workbook that takes a very long time to re-calculate so I am forced to turn off auto calc while working. However I need to re-calc some specific cells every time I update their formulas. I have an XLA addin automatically load that has a sub for calculating ONLY the selected cells withough re-calc-ing the whole nine yards. Sub CalcSelected() Selection.Calculate End Sub I am getting errors, I even get an error if I move the sub into a module in the very spreadsheet I am working on. Does anyone know how to do this correctly? Thanks in advance! Stan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
Calculate Based on Drop Down Item Selected | Excel Worksheet Functions | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
selected cells | Excel Worksheet Functions |