Looking to see if range contains a entry then clear the area calle
Clear

Any ideas greatfully received
Sub Macro7()

If Range("Clear_Area").Value < "-" Then
Range("Clear").ClearContents
End If
End Sub

VBA noo

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56331