I think you are confusing two issues.
The col( ) function never supported the use of WindowName! as a prefix. That notation was reserved for object properties, however the cell( ) function was written to allow that notation. If you have written scripts using
wksName!col(colNum)[rowNum] then they only worked correctly (by accident) when the worksheet named wksName was the active window. For example, if you had Data1 and Data2 windows and Data2 was the active window, then
nn=Data1!col(2)[1]
would actually return the value from column 2 of row 1 of Data2 (the active window) - not from Data1.
There are changes in the behavior of the cell( ) function between 6.1 and 6.1 SR1. Although I know it's of no comfort to you now, I argued against this change. What changed was the order of the arguments:
| Version | Syntax |
| 6.1 | [wksName!]cell(colNum, rowNum) |
| 6.1 SR1 | [wksName!]cell(rowNum, colNum) |
If you really have been using wksName!col(colNum)[rowNum] then a re-write of your code is necessary no matter what version you use. If you are using wksName!cell(colNum, rowNum) in 6.1, then you will (unfortunately) have to re-write the code to be compatible with 6.1 SR1 (and later). For example:
if(system.version<6.1073) nn=wksName!cell(myCol, myRow); else nn=wksName!cell(myRow, myCol);
Your suggestion that we re-compile the Help files is a good one. I will pass it along to Documentation. We have been relying on release notes and our web site to provide the latest information.
Edited by - greg on 01/05/2001 18:15:29
Col(colNum)[rowNum] change
Posted - 01/05/2001 : 1:39:37 PM
