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

HELP!!!! -- (Method Range of _Worksheet failed) ERROR!
 

Sometimes if a shape or chart object is active, assigning
values to cells fails. Ensure to select worksheet cell
prior to the assignment, i.e. range("A1").select or
activecell.select

-----Original Message-----
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
.

HELP!!!! -- (Method Range of _Worksheet failed) ERROR!
 

Thanks, but thats not the problem. In fact i get a "Select" method of
range failed (Error 1004) when I tried. Could the workbook or
worksheets be locked somehow? Te are not protected and the file is
not read only, but for some reason I cant write to any cells now.

Any help?

wrote in message ...
Sometimes if a shape or chart object is active, assigning
values to cells fails. Ensure to select worksheet cell
prior to the assignment, i.e. range("A1").select or
activecell.select

-----Original Message-----
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
rebo
oting 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
.

HELP!!!! -- (Method Range of _Worksheet failed) ERROR!
 

Hi,

Did you check what value "i" has before executing that line. i variable could be empty or minus or bigger than max row count(65536).

Or some cells in Column A in the ReportC sheet could be protected...

--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.



"Fusion" , iletide sunu yazdi om...
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

HELP!!!! -- (Method Range of Worksheet failed) ERROR!
 

Yes I checked all of that. "i" has avalue of 1, ande the cells,
worksheet and workbook are un-protected.

Help!

"Haldun Alay" <haldunalayATyahooDOTcom wrote in message ...
Hi,

Did you check what value "i" has before executing that line. i variable
could be empty or minus or bigger than max row count(65536).

Or some cells in Column A in the ReportC sheet could be protected...

--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.



"Fusion" <so , iletide sunu yazdi
om...
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
--