|re: Why would the target column equal 1 and not A? Wouldn't it have to be A?|
Did you try the code? If it had to be A, it wouldn't work as I wrote it, would it? However, since it does indeed work, then obviously it doesn't have to be A.
Counting from left to right, what number Column is Column A?
The syntax I used is the correct syntax for VBA code.
re: It's just the code and not the formula ... or is it both together?
The formula that Mike gave you will put the TODAY() function in B1. As we know, the problem (in this case) with the TODAY() function is that it updates every day.
Even if you put Mike's formula in a cell, as soon as the Worksheet_Change Macro runs, the formula will be overwritten by the date. As I've said a few times, the macro hard codes the date into the cell, just as if a user had entered it via the keyboard. In other words, it's going to overwrite whatever is in the cell.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.