Error Message with For Loop

**jadown** · 07-12-2013, 11:23 AM

Hi,

I am trying to create a loop that deletes rows within my worksheet. However, the data in the spreadsheet will change every month so I can't add definite ranges in my code. The code below works but when it finished I get a runtime error '10004' message. Please help me here.

Thanks!

HTML Code:

**AB33** · 07-12-2013, 11:57 AM

The code is looping 200 times. Why can not you select a range and delete?

**HaHoBe** · 07-12-2013, 12:06 PM

Hi, jadown,

you have to make sure that the last line of data is longer than 202 rows - with less you would go over the limits of Rows.Count when you try to delete rows. You should search for a constant and delete from there on. Your code may be further simplified to

Please Login or Register  to view this content.

Maybe you could post a workbook with some sample data to adjust the macro.

Ciao,
Holger

**jadown** · 07-12-2013, 02:21 PM

ExcelForumEx.xls

Here is the file a much smaller file. But the rows highlighted in yellow is what I want the loop to delete.

Thanks!

**HaHoBe** · 07-12-2013, 02:30 PM

Hi, jadown,

I altered the requirement to delete the single entry in Column C which would have been left as well:

Please Login or Register  to view this content.

Ciao,
Holger

**jadown** · 07-12-2013, 03:40 PM

Holger,

Thank you so much because I couldn't figure out how to get past this error all day.

Thanks Again!

**HaHoBe** · 07-12-2013, 04:22 PM

Hi, jadown,

you´re welcome - thanks for the feedback. If the solution fits your needs please mark this thread as Solved:

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Ciao,
Holger