I'm not sure why row 5 being selected makes a difference.

but one way:

with activesheet
if .range("c5").value = "" then
.range("c5").value = .range("d17").value
end with



kls wrote:

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!

--

Dave Peterson