VBA calculate cell range on change

[Russk68]

Hi All,

I have a worksheet that calculates manually.

I need to calculate only a range of cells when there is a change made in the same range with vba.

Your help is greatly appreciated!

Russ

 

[Joe4]

See here: https://www.extendoffice.com/documents/excel/3931-excel-only-recalculate-refresh-selected-cells.html

 

[Russk68]

Hi Joe

I should have been more specific.

The range of cells to be calculated doesn't change. I would like the calculation to happen automatically when a change is made in the same range.

Thanks!

 

[Joe4]

It looks like you should be able to adapt the VBA code in that link to do that.
If you need help in doing that, please provide more specific details.

 

[Russk68]

Ok
I'll give it a shot!

Thanks

 

[Russk68]

Got it!

Thank you!

 

[Joe4]

You are welcome!