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?"