Hi Nate,

there is a way how to speed it up:

You can select constants with specialcells and union this range with
second range, which is - from specialcells(xlcelltypeformulas) you
leave all with precedents.

Regards,
Ivan