Deleting Rows using VBA macro

**TrueTears** · 08-04-2013, 03:00 AM

Hi everyone,

Please refer to the attached workbook.

So there are 3 columns, column A is dates, column B is values related to a bank and column C is "exitflag". Essentially what I want to do is the following:

If the number is 1 under "exitflag", then I want to delete the entire row, eg, in row 2, "exitflag" takes on a value of 1, so I want the entire row deleted such that both the date and the value related to the bank is also deleted. By delete I mean I want the row removed so that the next row "shifts" up so that no empty row appears. Also note that there is also the number 1 under column B, eg, row 201, I do not want to delete those, I only want the rows deleted where exitflag has a value of 1.

I have written the following code but for some reason I don't think it works (or if it does work, I have to keep running it over and over, it doesn't do what I want in one go):

Please Login or Register  to view this content.

Also preferably I would like the code to be a "selection." code rather than specifying a range as I would like to reuse the code on other datasets but with different number of rows.

Much appreciated for any assistance!

**HaHoBe** · 08-04-2013, 03:18 AM

Hi, TrueTears,

if you want to use a For Each loop you should build a range to delete and delete that range after you passed the entire area. When it comes to deleting you may use a For Next loop starting from the bottom and working up:

Please Login or Register  to view this content.

Ciao,
Holger

**nilem** · 08-04-2013, 03:46 AM

Hi TrueTears,
as an option
in your example, try selecting entire columns A:C and run this macro

Please Login or Register  to view this content.

**HaHoBe** · 08-04-2013, 05:36 AM

Hi, TrueTears,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.vbaexpress.com/forum/show...sing-VBA-macro

Ciao,
Holger