I'm still not fully understanding you.....I think what you mean is you want the date logging to be in column Z rather than B.....and this will do that:

range("Z" & target.row).value = Range("A" & target.row).Value