Hi ,
I have been trying to autofill dates of the month for
particular sheet, but it throws me this error Method Range of objec
'_Global' failed.

The following code snippet is what iam using

'Fill in the Dates for the Month in the first column
objExcelRep.Worksheets("DataMatrix").Cells(intCell IndexRow, 1)
Month(Date) & "/01/" & Year(Date)
objExcelRep.Worksheets("DataMatrix").Cells(intCell IndexRow
1).Select
strRange = "A" & intCellIndexRow & ":A" & intCellIndexRow
MonthNoOfDays - 1
Selection.AutoFill Destination:=Range(strRange), Type:=xlFillDays

Am i missing something?

Thanks,
Joh

--
maverick200
-----------------------------------------------------------------------
maverick2005's Profile: http://www.excelforum.com/member.php...fo&userid=2662
View this thread: http://www.excelforum.com/showthread.php?threadid=39902