Manual calculating selected cells only

Manual calculating selected cells only

Hi,

Currently I have a spreadsheet which I have set to manual calculation. When I press F9 it recalculates everything on the spreadsheet which takes 30mins.

Is there any way that either of the following can be done.

1. A macro can be run which only manually calculates selected cells – Cells Q-AE

2. The sheet is set to automatic calculation but it ignores cells A-P. Then be able to manually calculate using a macro cells A-P

The spreadsheet I have gathers information in cells A-P and then in cells q-AE it uses formula but the formula will not work unless I press F9 or manually go into the cell and press enter.


I found this code, can it be modified to help me achieve what I want, e.g can I add a line to this so it calculates only Q-AE?

Please Login or Register  to view this content.

Hello pauldaddyadams,

Here is macro you can use to calculate the cells you want and not the entire worksheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi thanks for getting back to me.

Is there a way it can do all sheets rather than just the active sheet?

Hello pauldaddyadams,

Use this macro to calculate the same range on every sheet...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi Thanks for that!!

Is there a way the sheet is can be set to automatic calculation but also set to ignores cells A-P.

Hi,

This code didnt work for me?