View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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