| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill column with dates of month depending on month in A1
I'm trying to figure out the following. A1 contains first of month and
is formated as Mmmm yyyy, A6 is =A1 and A7=A6+1 and so on formated as mm/dd/yyyy. I want to programatically fill column A with the rest of the days of the month when the user changes A1. I'm using Private Sub Worksheet_change(ByVal Target As Range) to clear the old days and then copy A7 down for the remainder of month. Can't figure out how to make it stop at the end of the month. Thanks in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUM of column values depending on the heading (month) | Excel Discussion (Misc queries) | |||
| How do I add totals from a range of dates depending on the month? | Excel Worksheet Functions | |||
| How do I sort a column of dates by the month? | Excel Discussion (Misc queries) | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
Threaded Mode
