View Single Post
  #1   Report Post  
Keyrookie Keyrookie is offline
Member
 
Posts: 84
Default Auto populate date VBA code

Is there a code that allows a date to be entered and succesive dates to populate?

Right now I have a date in B9 and in B10 I have "=B9+1" which is copied down the column to complete 365 days.

My concern is an inerrant click could delete the formula(s) and disrupt the sequence.

Thanks in advance for the help.