|First, let's get the terminology correct so that there is no confusion about what we are trying to do.|
re: "field A5, fields C6 thru C14"
A5, C6, C14, etc. are cells not fields.
re: "The fields in C6 thru C14 would change..."
Do you mean the values in cells C6 thru C14 would change..."?
re: "generate fields C6 thru C14 with dates of 2/1 thru 2/8"
Something's missing here. The range C6:C14 contains 9 cells. 2/1 thru 2/8 is only 8 dates.
Please clarify what you are trying to do.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.