Moving right from a Cell location

[howzthat]

....I'm a newbie to VBA.

I'm using Find command to search for all the instances of a string in a column.
A variable 'C' (Dim As Range) is used to store result from Find command.
Each time a match is found, I need to move couple of columns(say 7) right and store something (say "Yes") in corresponding column.

Example: if my Find search has given me C3 location then I would have to store "Yes" at J3 and so on.

My question is how do I change value fo C so that it automatically points to 7 columns right??

 

[JoeMo]

....I'm a newbie to VBA.

I'm using Find command to search for all the instances of a string in a column.
A variable 'C' (Dim As Range) is used to store result from Find command.
Each time a match is found, I need to move couple of columns(say 7) right and store something (say "Yes") in corresponding column.

Example: if my Find search has given me C3 location then I would have to store "Yes" at J3 and so on.

My question is how do I change value fo C so that it automatically points to 7 columns right??

Once C is found, add this line:

C.Offset(0,7).Value = "Yes"

 

[AlphaFrog]

C.Offset(,7).Value = "Yes"