VBA command for calculate except data tables

[Gary Page]

Hi all, new to this group.

Is there an equivalent command to application.calculate that runs a calculation of everything except datatables? Does anyone know if setting to semi automatic and then back to manual forces a calculation?

Many thanks

Gary