Newbie VBA Question

Joined
Sep 26, 2010
Messages
2
Reaction score
0
Hi All,

Excuse my ignorance, but I have just joined the forum today. Judging from previous answers this seems the place to be.

I'm trying to learn VBA all by myself but seem to be hitting a wall with what should be a very simple code.

I'll explain my problem as clearly and concisely as possible:

I am trying to set the value of a cell to "Y" depending on the value of another two cells.
For example, if Cell A < Cell B, then Cell C value should be "Y".
In the circumstances where the value of A changes, and is no longer less than Cell B, I want Cell C to
continue to show a "Y". That is, once the condition is triggered, and Cell C= "Y", I don't want the value to
be changed again.

I've tried using a Range value in an IF statement but to no avail. I think I'm missing something blatently
obvious, but I still can't fix it!!!!!!!!!!!!!!!!!!!

Many thanks to anyone who replies.



Cheers,

Herbie1809
 
Back
Top