Visual Code to make sure value is greater than 0
On Oct 28, 10:21*am, Jeremy wrote:
I am trying to use a visual statement to make sure a value in an active cell
is greater than 0 and am not able to do it properly. *This cell has a value
that comes from another cell. *Below is the code I am looking at.
If ActiveCell.Address < "0" Then
Thanks
Get rid of the quotes around 0 or use selection < 0 or
selection.value < "". All are options. It is best if you can refer
to the range instead of selcting a cell though. If Range("A2") < ""
Then. This peeds up your code.
Jay
|