Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code:
..Range("A1:E1").Select Selection.AutoFill Destination:=Range("A1:E" & MCLastRow), Type:=xlFillDefault The problem is B1 and E1 have a month and a number respectively. I want the same month and same number to filldown but it's incrementing like this: January 1 February 2 March 3 etc. I want it to fill down like this: January 1 January 1 January 1 How do I make this happen? |