All Forums  Origin Forum for Programming  Forum for Origin C  problems in using the function DeleteRow( )

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by blt2si[/i] [br]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 [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.