Hello:

As part of the macro that I am writing, I need to set up two conditions for
a given cell, ie: if the value is less than zero AND its abolute value is
greater than x, then enter the text string "N/A" into the cell.

Any thoughts on how this can be done. New to macro writing so this one has
me stumped.

thanks for any help that the group can provide.


--
sd

Set givenCell = Range("H10")

If givenCell.Value < 0 And givenCell.Value x Then
givenCell.Value = "N/A"
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"iamn94" wrote in message
...
Hello:

As part of the macro that I am writing, I need to set up two conditions
for
a given cell, ie: if the value is less than zero AND its abolute value is
greater than x, then enter the text string "N/A" into the cell.

Any thoughts on how this can be done. New to macro writing so this one
has
me stumped.

thanks for any help that the group can provide.


--
sd