Hello Everyone!
I am building a xls based tool where there s a 'input' sheet that require data entry. The subsequent sheets (5 in no.) are 'calculation / result' sheets based on values from the 'input' sheet.
Now to initiate all calculations I have used the code - Application.CalculateFull.
This code is perfect as it forces a full calculation in all the sheets also including the 'input' sheet with press of a Tab/button (which I have created).
What I ideally want is that in the 'input' sheet the calculation to be automated, while in the remaining it remains the same (ie forced calculation with a click on the Tab). I tried using Activesheet.calculate in 'input' sheet but it does not help.
Can anyone tell me how to resolve this?
Bookmarks