Runtime error 1004
Autofill method of Range class failed
my code :
Code: Select all
Selection.AutoFill Destination:=Range("L2:L" & intMyCount), Type:=xlFillDefault
Range("L2:L" & intMyCount).Select
intMyCount is based on the number of records counted.
Any ideas ?