I can automatically insert the time in the column to the right of one cell
by using Select Case Target Address in the Worksheet Change event by
specifying each individual case.

Is it possible to insert the time in a range of cells that I specify (i.e.
C7:C23) if I enter a date into B7:B23? I can't seem to perform the event
unless I specify the case for each individual target.

Thanks,

Sam