| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill method of range class failed - sometimes
HI all, I am using Excel 97 (it has to work under it) Here is the code I have that breaks .... Code ------------------- prev_points = 4 'this changes in a different place I just put it here so you can see it's value Range("Calculations!G" & CStr(prev_points + 1)).AutoFill Destination:=Range("Calculations!G" & CStr(prev_points + 1) & ":Calculations!G" & CStr(21 + 1)), Type:=xlFillDefault ' Cell G5 has a formula that needs to be copied down. ------------------- ... Well sometimes it doesn't break. Any ideas why -- Intellihom ----------------------------------------------------------------------- Intellihome's Profile: http://www.msusenet.com/member.php?userid=147 View this thread: http://www.msusenet.com/t-187044591 |
| 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) | |||
| AutoFit method of Range class failed | Excel Programming | |||
Threaded Mode
