Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I get this under all version of Office I have tried. Currently I am
using 2003, but I got the same message with XP and 2000. Here is my code: Sheets("ReportC").Range("A" & i) = "Appendix" Basic huh. The error will occur randomly. This code worked great all morning, then I got back from lunch and I get the error message. This happens ALL the time. Anytime I am trying to write to a cell I may get this error. Nothing seems to fix it, not even rebooting my pc. Eventually it will clear itself up and I can run the code again (exactly as it appears above). Any ideas? Is there a better (correct) way to write values to cells. Thanks in advance, SOS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Method 'MailEnvelope' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
error 1004 Select method of Range class failed | Excel Programming |