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
i forgot to add this part. ActiveCell.Address returns the cell
address like A2 B9 so forth. This woudl never be 0. You could use
ActiveCell.Value.
Jay
|