LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to auto-populate with current date Bill-Ace Excel Discussion (Misc queries) 1 June 26th 09 02:58 PM
How to Auto populate dates from a given start date Jim Hammerel Excel Programming 2 June 14th 08 09:29 AM
how do you auto populate the date in excel? ccb/ws New Users to Excel 2 June 13th 06 07:46 PM
timesheet auto populate date? ll Excel Programming 1 May 22nd 06 03:52 PM
HOW ?Excel chart auto insert /populate a code based on date MikeR-Oz New Users to Excel 6 December 22nd 05 12:16 PM


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"