"John Green" wrote in message ...
Destination should be a range object, not a string.

srcRng.AutoFill Destination:=Range("$A$1:$C$20")

Oh yes! It worked!

Thank you,
--
Syed Zeeshan Haider.
http://szh.20m.com/


-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"