Gulshan_sharma
New Member
Hi,
I have a spreadsheet that has functions in excel cells & some VBA code.
The spreadsheet automates my work in a way that it pulls data from other sheets do calculations & finally create rows of results which i use for comparison etc.
My problem is that I have an actuarial function coming from an addin which is causing the VBA code to skip.
Till now I was doing following in code to handle the situation
a) switching to manual calculation mode
b) deleting the cells containing the actuarial functions
c) switching back to automatic calculation mode
d) run the remaining modules of code
e) finally paste the cells in a) with actuarial function
Can I have a concrete workaround to this temporary setup?
I can elaborate if there is more detailing required around my question, though cant share the workbook etc as confidential matter in there.
I have a spreadsheet that has functions in excel cells & some VBA code.
The spreadsheet automates my work in a way that it pulls data from other sheets do calculations & finally create rows of results which i use for comparison etc.
My problem is that I have an actuarial function coming from an addin which is causing the VBA code to skip.
Till now I was doing following in code to handle the situation
a) switching to manual calculation mode
b) deleting the cells containing the actuarial functions
c) switching back to automatic calculation mode
d) run the remaining modules of code
e) finally paste the cells in a) with actuarial function
Can I have a concrete workaround to this temporary setup?
I can elaborate if there is more detailing required around my question, though cant share the workbook etc as confidential matter in there.