Or do you mean:
With ActiveCell
If Range("J61").Value500 Then
.Value=500
Else
.Value =Range("J61").Value-1
End If
End With

NickHK

"icetrey" wrote in
message ...

I have a cell formula -=IF(J61500,500,J61*-1)- that I want to put
into a macro. How would this formula need to be typed in a line of
code.


--
icetrey
------------------------------------------------------------------------
icetrey's Profile:
http://www.excelforum.com/member.php...o&userid=20329
View this thread: http://www.excelforum.com/showthread...hreadid=565031