Macro can't run otherwise working formula

I'm trying to run a short macro to set up an "Audit Selection" population of data. But I always get an error when the script gets to the part of entering the formula:

=LET(d,FILTER('Policy List'!A4:A5000,'Policy List'!A4:A5000<>""),r,ROUNDUP(ROWS(d)*50%,0),TAKE(SORTBY(d,RANDARRAY(ROWS(d))),r))

Another user on this forum helped me with the formula and it works great when I just paste it in the cell. Is there some reason I can't plug it into a macro?

Audit Selection Macro.txt

Debug.JPGError Screenshot.JPG