Autofill dates

[Eytch]

I used a selection statement to define a range using cells. Now that I have the column of cells comprising the area selected I want to format the first cell a date and autofill the remaining cells with successive days of the month. The area was defined using cells in the range statement (Range(Cells (TheRow,3), Cells(8,3))). How do you autofill a selected area without using cell addresses? Any suggestions.

Thanks,
Tripoli

 

[PHV]

Something like this ?
Selection.DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:=xlDay, Step:=1, Trend:=False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886