Loop to delete rows based on value.

**bopsgtir** · 11-04-2012, 06:12 AM

I have the below code but it doesnt seem to work, ive run through the code and if seems to be looping and looking at each cell but it never executes the rows(Rw).delete.

is there something im missing here?

Please Login or Register  to view this content.

**RHCPgergo** · 11-04-2012, 06:21 AM

Hi,

you could try going through the code with F8 to execute the code line by line and see what each step does. (Minimize the code window to be able to see the worksheet too.)

edit: you could also add messageboxes to check what values are assigned to your variables. For example:

Please Login or Register  to view this content.

This way you can easily debug your code and see where it goes wrong.

**TMS** · 11-04-2012, 06:48 AM

You're always looking at the same cell: Cells(LastTableCell,"E") ... Should be Rw.

Regards, TMS

**AB33** · 11-04-2012, 07:00 AM

Try

Please Login or Register  to view this content.

**bopsgtir** · 11-04-2012, 12:26 PM

thanks tmshucks i see what i was doing now, im getting there slowly, many thanks works fine now.

**TMS** · 11-04-2012, 12:54 PM

You're welcome.

Loop to delete rows based on value.

LinkBack

Thread Tools

Rate This Thread

Display

Loop to delete rows based on value.

Re: Loop to delete rows based on value.

Re: Loop to delete rows based on value.

Re: Loop to delete rows based on value.

Re: Loop to delete rows based on value.

Re: Loop to delete rows based on value.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions