| Author |
 Topic  |
|
|
blt2si
Germany
37 Posts |
 Posted - 01/30/2003 : 04:22:43 AM
|
Hi all,
The DeleteRow() function is not working as i expected.The following script includes this function. When this executes it deletes every second row in the worksheet starting from row number 2(i.e:2nd,4th,6th,8th ..and so on) instead of deleting 2,3,4,5,6,...rows.If the loop starts with row number 0 then its start deleting from row number 0 and also it includes a starnge logic i.e: If the indiacted row(which is intialized in loop here '2') contains strings then it starts deleting all rows which are having strings,if it contains values then it deletes all the rows which have values whether they are equal or not.
Can anyone tell me the exact description of this function and how it works?
for(row=2;row<nofrows;row++)
{
wks.DeleteRow(row);
}
Thank you,
Blank |
|
|
rlewis
Canada
253 Posts |
Posted - 01/30/2003 : 10:28:18 AM
|
When a row is delted from a worksheet, the rows below it are renumbered. To get around this you should delete rows from the bottom up ... Try this
for(row=nofrows;row>2;row--)
{
wks.DeleteRow(row);
}
|
 |
|
| |
Topic |
|
|
|
problems in using the function DeleteRow( )