Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill Method
Hello Experts,
I have Excel 97 Pro on Win98SE. I am trying to use AutoFill Method to fill from A1:C1 to A1:C20 using following syntax: '------------------------------------------------------ Dim srcRng As Variant Set srcRng = Range(Selection.Address) ' here Selection.Address = "$A$1:$C$1" srcRng.AutoFill Destination:="$A$1:$C$20" '------------------------------------------------------ I am getting following error message: ============================ Run-time error '1004': AutoFill method of Range class failed ============================ What's wrong with my code? Thank you, -- Syed Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Autofill method of range class failed | Excel Discussion (Misc queries) | |||
Autofill method of range class failed | Excel Discussion (Misc queries) | |||
Please post this thread a correct full method, method about | New Users to Excel |