I have a workbook where I have to carefully control calculation activity to only those cells and objects that need to be updated. I have a chart located on sheet1 that needs to be updated. My approach is
This generates an error. What is the preferred code here?Dim Cht as Object Set Cht = ActiveChart Cht.Calculate
Thanks in advance for any assistance
Bookmarks