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