you may have to play around with the offsets to get them right.
the first number (0) represents the row number and you'll want to leave that at zero becuase you want to effect the row you're in. The second number (1) represents the column and that's the one you may need to tinker with. The key thing to remember is that Offset is zero based, so for example if you're in cell "A1":
.offset(0,0) 'refers to cell A1
.offset(1,0) 'refers to cell A2
.offset(0,1) 'refers to cell B1
also, if for whatever reason you change that code around so it's not using the With Target line, Offset is a member of the Range object, so a fully qualified line would look like
Range("A1").Offset(0,1) = 5 'puts 5 into cell B1