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