I tried this
Range("A" & intCellIndexRow).AutoFil
Destination:=objExcelRep1.Worksheets("DataMatrix") .Range(strRange)
Type:=xlFillDays
and still it throws me the same "_global" error.
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