Hi julio,
Some syntax problems exist in your script. For a number to referred to the column, you don't need to use the $ sign, such as col(7) is OK, but not col($(7)). And to get the string in a cell, the $ sign is needed after the cell range. You can refer to this page for more details about string variable and this page for more information about substitution notation.
Your script can be changed like:
nRows=wks.nRows;
for(ii=1;ii<=nRows;ii++)
{
if(col(7)[ii]>2)
col(9)[ii]$ = col(4)[ii]$;
}
Penn