Just a guess ... instead of

Selection.AutoFill Destination:=Range
(mySourceDataRng), Type:=xlFillDefault

You want

Range(mySourceDataRng).AutoFill Destination:=Range
(mySourceDataRng), Type:=xlFillDefaul

--
Message posted from http://www.ExcelForum.com