Visual Code to make sure value is greater than 0

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

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 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
Click to expand...

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
 
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
Click to expand...

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
 
Hi,
you can use conditional formating to highlight the cell if the value is less
than 0, in excel 2007, home, conditional formating, Highlight cells rules,
Less than, choose 0 and then choose the color
 
I am not able to use conditional formating on what I am looking for. There
is more visual statement I am using to do what I am looking for. If the
value is 0 I don't want it to execute my next step in visual.
 
Back
Top