The message i get is ' Run-time-error '1004'

Application-defined or object-defined error

I've inherited this script and be honest I'm no VBA expert. How do I see if the formula results in an error.