Syntax if replacing a cell ref. with a named range?

[jfarlow]

Hi

I've got a macro that currently says:
If .Range("DP3").Value > 0 Then
MsgBox "ONE-UP RATING MUST BE ENTERED FOR ALL EMPLOYEES WITH A RECOMMENDATION"'Cancel = True
Exit Sub
End If

I want to replace "DP3" with the new named range of Rec_No_Rating

Can someone help me with the correct syntax using the name rather than the cell ref?

thanks

[NBVC]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here