excel 2007

  User-81724FED-925D-49B3-BCBB206EFD620277 21:50 11 Jan 2008
Locked

how do you tell it to insert dates in a column in increments of 7 days i used to be able to select it on my earlier version by selecting format cells - series but i cannot find how to do it in 2007 version i must be missing something or am i thick lol

  VoG II 21:57 11 Jan 2008

I don't think that there is an equivalent.

In A1 enter 01/01/2008

in A2 enter 08/01/2008


Then select A1 & A2, hover the cursor over A2 until it turns into a + then left click and drag down.

nothing seems to be happening

  VoG II 22:20 11 Jan 2008

OK then on the Developer tab select Visual Basic, Insert > Module then paste in

Sub FillDates()
Range("A1:A2").AutoFill Destination:=Range("A1:A16"), Type:=xlFillDefault
End Sub

Close the code window then Macros, highlight FillDates then click the Run button.

thanks for help

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

This is what design agencies will look like in 2032

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache