| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating dates
I have a range(thisRange) that I would like to populate the first column
with dates from January 1 to december 31 of an x year Sub populateDate(yr as string) Dim Myyear as date dim thisrange as string Dim xyear as string Myyear = "Sales "& year(Worksheets("daily").range("b2").value thisrange = "sales" & myyear xyear - year(myyear) How do I put in the dates for xyear? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating Row with dates | Excel Worksheet Functions | |||
| Populating dates into a 2003 Excel worksheet | Excel Discussion (Misc queries) | |||
| formulas populating dates - 1st Tuesday | Excel Worksheet Functions | |||
| Populating a column with calender dates............ | Excel Worksheet Functions | |||
| populating a list box with weekly dates | Excel Worksheet Functions | |||
Threaded Mode
