Click any Row Header and then Run:

Sub tester()
With Selection
If .Columns(3).Value = "" Then
.Columns(3).Value = Range("D17").Value
End If
End With
End Sub

Careful with the Hard-coded D17 Reference Above;

HTH


"kls" wrote in message
...


If having selected Row 5, I want my macro to evaluate Range("C5')'s
value. If it is found that it is equal to "", I want to then make it
equal to Range("D17")'s value.

Hope this is clear

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!