since you offer no particulars, here is some contrived code

the 1 is placed in column F for a value in column A of 3 for the 1st through
10th row


for each cell in Range("A1:A10")
if cell.Value = 3 then
cell.offset(0,5).Value = 1
else
' clear column F if not?
'cell.offset(0,5).clearcontents
end if
next

--
Regards,
Tom Ogilvy


"chris46521" wrote:


I would like to create code that will check to see if there is a certain
value in a particular cell, and if there is place a "1" in another cell
in that row. I think I know how to do the If statement, but I don't
know how to write a value in another cell in VBA. Thanks for any help
or suggestions.


--
chris46521
------------------------------------------------------------------------
chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909
View this thread: http://www.excelforum.com/showthread...hreadid=565243