Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis will be far from the most efficient solution but it's fully dynamic as far as I can tell. One macro is doing the higher primes and the other is doing lower, before comparing.
N.B. I reckon I made this challenge a lot harder than I needed to
Used a combination of an iterative macro to keep looping until I found a solution with a batch macro nested inside which check each increasingly distance number from the starting point to see if it was prime.