Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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?" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta | Excel Discussion (Misc queries) | |||
Excel 2000 and Excel 2003 in Office 2003 | New Users to Excel | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) |