Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating cells on workbook_open failing without message
I have to refresh 2 cells when the workbook is opened. I have an On Error
surrounding my code that gets run. The err.Description is always empty yet my error message box is being shown and my cells don't open. Each of the two cells are named - pdate and fdate. They call a function which is located in an addin. I can manually update these by clicking F2 and pressing enter in each cell. Any idea what to look at? Once person said that something else that depends on these cells may be failing and the error just isn't being displayed. Thanks, Joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating cells on workbook_open failing without message
Hello,
When mentioning calculating cells, do you mean 1.Call a AddIn function and set the returned value to the range.Value, or 2.The cell's Range.Value2 is set to an UDF expression which is implemented in another Addin? Generally, we can call the Range.Calculate method to update the UDF value, http://msdn.microsoft.com/en-us/libr...op.excel.range .calculate(office.11).aspx Best regards, Ji Zhou Microsoft Online Community Support |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display message while calculating forumlas | Excel Discussion (Misc queries) | |||
Message box whilst calculating | Excel Programming | |||
Calculating: (1 Processor(s)): 25% MESSAGE ON STATUS BAR | Excel Discussion (Misc queries) | |||
Calculating Cells n% message in Status bar | Excel Discussion (Misc queries) | |||
Workbook_open : Putting in message in titlebar (Visual Basic) | Excel Worksheet Functions |