Writing Text in a Cell Relative to another cell

[cicconmr]

Pretty basic question, but unsure what to search for to get the answer on the forums.

I have a routine that finds a cell using a for loop, so let's say it finds the cell is E17. I then want to put an integer value in H17 (same row), because H is the column where I am recording whether or not I have found this certain value.

I've surprsingly never had to do this...and am not sure where to begin.

Matt

 

[VoG]

Try like this

Found.Offset(,3).value=1

where Found is a range variable (your found cell)

 

[missgari]

Hi Matt,

supposing you have the found cell in the variable range FoundCell, I'd do something like:

Range("H" & FoundCell.Row).Value = Whatever

then you put in Whatever the value you need or the reference/formula that you want to link this cell to... hope it helps!

 

[cicconmr]

This is great guys, thank you for the speedy response.