loop

[vimalanathk]

hi,

can some pls help with the script which gives

do

if "the cell begins with a particular word"

select the entire row

delete

move to next row

end loop if the row is blank

script ends

regards,
vimala K

[JOHN H. DAVIS]

Please use code tags when posting.

Please Login or Register  to view this content.

Assumes the particular word is "word" and the values are in Column "A".

[vimalanathk]

do i need to give the entire text of the cell which i want to delete....

i just want to give the starting word of the cell...

by using the above script cursor is not moving from cell a1 and no action is taking place in the work book

regards,
vimala

[stnkynts]

If i could respectfully amend John's code this might make it a little easier for the OP to edit to there desire:

Please Login or Register  to view this content.

Edit: I just noticed that this may be a cross post http://www.excelforum.com/excel-prog...continues.html.

[vimalanathk]

macro is running only between the below lines

If Left(Range("A" & i), lCount) = str Then Rows(i).Delete
Next i



and no rows are getting deleted

[vimalanathk]

Hi,

in the attached excel i want to delete the rows which are starting with location, mcp and last

regards,
vimala

[stnkynts]

It would have been nice if you would have mentioned multiple words. I am curious how you tried to put the multiple words in to get it to work. Also, you were probably experiencing a "case" issue.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.