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