View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fusion[_2_] Fusion[_2_] is offline
external usenet poster
 
Posts: 3
Default HELP!!!! -- (Method Range of _Worksheet failed) ERROR!

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