Here's what I'm trying to accomplish.

When macro runs, search column D:J on the GrossNet sheet, and if a value greater than 50 or less than -50, display a prompt "Value greater / less than 50 present, do you want to proceed?". If yes, continue macro, if no, end macro.

I have some code below, but I am not certain on how exactly to integrate. Any assistance would be appreciated!

I think this formula works for the data validation, unless there's a better method for accomplishing this?

Code:
=IF(OR(MAX(D:J)>50,MIN(D:J)<-50),1,0)
I have the following code for the actual message box, which I know is pretty basic.

Code:
If MsgBox("Value greater / less than 50 present, do you want to proceed?", vbYesNo) = vbNo Then Exit Sub