Run Macro and Calculate Formula ONLY in current Worksheet

Hi Deb,

Have you set the Calculation Mode to Manual?

You can press Ctrl+Shift+F9 to calculate just the active sheet.

The Worksheet_Calculate event fires AFTER the worksheet is calculated, so you probably can't control the amount that gets calculated here.

Perhaps the code ActiveSheet.Calculate can help in a macro. (Selection.Calculate can be used to calculate a range.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Thanks for answering me! I appreciate it.

To clarify, are you suggesting that I try:

1. Set the Calculation Mode to Manual
2. Add the Code ActiveSheet.Calculate

Probably a stupid question (I have memory problems, so although I've taken a few courses, it doesn't stick with me)...

Where in the above VBA would I put ActiveSheet.Calculate ?

Thanks for answering me! I appreciate it.

To clarify, are you suggesting that I try:

1. Set the Calculation Mode to Manual
2. Add the Code ActiveSheet.Calculate

Probably a stupid question (I have memory problems, so although I've taken a few courses, it doesn't stick with me)...

Where in the above VBA would I put ActiveSheet.Calculate ?

Hi Deb,

Yes, I am suggesting that you try setting the Calculation Mode to Manual.

This will stop the workbook from recalculating all the time (which can be very irritating with a WB full of formulas).

If you press F9, the whole workbook will be recalculated. If you press Shift + F9, just the current sheet will recalculate.

Pressing Shift +F9 or F9 will cause the Private Sub Worksheet_Calculate event to run AFTER the calculation has finished. This is why I was trying to say that you could use ActiveSheet.Calculate somewhere else. Perhaps another subroutine.

If using my first suggestion works - ignore the extra code. Sorry if I confused you!

I hope this is a little more helpful, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".