Hello Experts,
A friend of mine, who is not a fond of programming, has given me a certain
task for research purposes. I have to accomplish this task in Excel with the
help of its VBA.
I have Excel 97 Pro on Win 98 while my friend has Excel 2003 Pro on WinXP
2003 Pro SP1.
I have developed some huge and complex code on my PC.
When I took this code to my friends PC, and ran it, first of all it gave me
an error on the last part of following line:

For Each cCell in [A3:A2000]

The error said "Object required".

When I replaced [A3:A2000] with Range("A3:A2000"), the code began to work.

How come a piece of code which works in Excel 97 Pro does not work in Excel
2003 Pro?
Are there any other conflicts like this one?
Where can I find them? URL etc.?

Thank you,
--
Syed Zeeshan Haider.
http://szh.20m.com/
http://gomusharrafgo.20m.com/

-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"

Code that works in earlier versions of Word or Excel or ... does not
necessarily work in later versions due to changes in the way things work, or
in new bugs in the later versions, or in bugs being exposed in code one
thought was correct.

The message you received implies that cCell is not an object or Cell data
type or Excel 97 wants the more appropriate Range("A3:A2000").
--
http://www.standards.com/; See Howard Kaikow's web site.
"Syed Zeeshan Haider" wrote in
message ...
Hello Experts,
A friend of mine, who is not a fond of programming, has given me a certain
task for research purposes. I have to accomplish this task in Excel with
the
help of its VBA.
I have Excel 97 Pro on Win 98 while my friend has Excel 2003 Pro on WinXP
2003 Pro SP1.
I have developed some huge and complex code on my PC.
When I took this code to my friends PC, and ran it, first of all it gave
me
an error on the last part of following line:

For Each cCell in [A3:A2000]

The error said "Object required".

When I replaced [A3:A2000] with Range("A3:A2000"), the code began to work.

How come a piece of code which works in Excel 97 Pro does not work in
Excel
2003 Pro?
Are there any other conflicts like this one?
Where can I find them? URL etc.?

Thank you,
--
Syed Zeeshan Haider.
http://szh.20m.com/
http://gomusharrafgo.20m.com/

-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"