Calculate a Specified Range Only

[John Vieren]

Dear all,

Thank you for reading my post.

I am a beginner with VBA and have used record macro to make my macro.

Currently the macro uses the calculate this sheet only, but it is running very slow.

I have also tried the macro with calculate active sheet only, but that also runs very slow.

I would like to run my macro with calculate a cell range (e.g. A1:D5) , which uses a range name (e.g. Range_1).

Could someone please give me the proper syntax?

I found Range.Calculate and is it as simple as putting in my macro Range_1.Calculate?

Thanks for any help and apologies if this is a really dumb question?

Kindest regards JV

[Sniper]

Hi John

Can you please attach an example.

Thanks

[teylyn]

syntax goes like this:

Worksheets("Sheet1").Range("A1").Calculate

replace A1 with your defined range name.

[John Vieren]

Thanks that works fine, much appreciated and regards JV