![]()
Sub jan2dec() Dim FillAddress As String FillAddress = "g13" Range(FillAddress).FormulaR1C1 = "Jan" Range(FillAddress).Resize(ColumnSize:=12).DataSeries _ Rowcol:=xlRows, _ Type:=xlAutoFill, _ Date:=xlDay, _ Trend:=False End Sub
![]()
Sub jan2dec() Dim FillAddress As String FillAddress = "g13" Range(FillAddress).FormulaR1C1 = "Jan" Range(FillAddress).Resize(ColumnSize:=12).DataSeries _ Rowcol:=xlRows, _ Type:=xlAutoFill, _ Date:=xlDay, _ Trend:=False End Sub
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks