Applying a rule to all ROWS issue

Hello All,
I'm new to Excel and have hit an issue that i'm sure is very easy to correct, but has me stuck.
I have a simple macro in VBA that changes a cell value based on a different cell's value. I need to apply this rule to all columns in my worksheet:

If Range("I4").VALUE = "Text 1" Then Range("J4").VALUE = "Yes"
If Range("I4").VALUE = "Text 2" Then Range("J4").VALUE = "No"


Any help would be appreciated.

Most kind.

Not sure what you mean by all columns, but is this on the right track?

Please Login or Register  to view this content.

Hi dangelor,
Many thanks for your reply.
I'll need to run that when I have a bit more time to experiment.
What i'm trying to do is apply a rule to all columns i.e Cell I4 text changes J4; I5 changes J5; I6 changes J6 and so on for several thousand.
If your formula is correct then please accept my sincerest gratitude.
Most kind.

It should do as you say, but first try it on a copy of your data.

Hello again,
I have tried your suggestion but it didn't work sorry. Would you be kind enough to suggest another solution please?

Kind regards
Mary

Posted in the wrong forum (VBA)

Many thanks for your help, but I cant see the formula that you have written when I click the link.