ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I Want to Caculate only ONE Cell !!! (https://www.excelbanter.com/excel-programming/324677-re-i-want-caculate-only-one-cell.html)

Ajtb

I Want to Caculate only ONE Cell !!!
 
Hi Mahmoud

1. Set your spreadsheet to manual calculation.

2. If formula is in A5 then range("A5").Calculate
should do the trick.

Regards

Andrew Bourke


Mahmoud Metwally wrote:
Dear
I Wannt to make the excel sheet only calculate one cell that I put a rule in
it.
Also, can I make the Excel refresh automatically every certain period of
time to calculate that Cell.?


Thank You




All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com