I have a spreadsheet and I need to fill/series dates weekdays. I have done this and stored it as a macro.
What I would like to do is set the start date to a cell location and the stop date to another cell location. Is this possible and if so can you please show me how it would be coded. In the code above I recorded a macro as I used the Fill Series tool. The Stop date I had to enter manually. I want to automate this process.
Thanks,
Code:
Sub Fill_Right_Dates()
'
' Fill_Right_Dates Macro
'
'
Selection.DataSeries Rowcol:=xlRows, Type:=xlChronological, Date:= _
xlWeekday, Step:=1, Stop:=42321, Trend:=False
End Sub
What I would like to do is set the start date to a cell location and the stop date to another cell location. Is this possible and if so can you please show me how it would be coded. In the code above I recorded a macro as I used the Fill Series tool. The Stop date I had to enter manually. I want to automate this process.
Thanks,