Macro to delete entire rows based values in columns

**shamade2107** · 03-06-2009, 10:44 AM

Hi all,
I'm currently working on an excel sheet and need a macro that can delete entire rools based on values in column B. Attached is a sample of the sheet, row 1 to 72 is a letter template, but worksheet functions (Vlookup) is used to determine the values in row 24 to 54.
I need a macro that will delete entire between rows 24 to 54 that have no value and if all the rows (24 to 54) has no value it should delete rows 1 to 72.

Rows 73 to 144 is another letter template, among which rows 96 to 126 are the rolls that the values are determine by worksheet functions. Macro should also do same as the above template. this also apply to the remaining templates as i have up to 30 letter templates on the excel sheet.

Many thanks

**shamade2107** · 03-13-2009, 02:30 AM

Hi all,
I have not seen any reply on the be VBA, can someone help please?

**DonkeyOte** · 03-13-2009, 03:42 AM

The below assumes if B is blank the row should be deleted & that the last row with data in Column B is always the last row of the last template.

Without seeing the Formulae in place and/or a complete sheet with all templates in place it's hard to make any concrete assertions... as you've discovered the less info you provide the less likely you are to get an answer.

Please Login or Register  to view this content.

Change the text in red to reflect the name of the sheet containing the templates.

**shamade2107** · 03-13-2009, 08:55 AM

Many thanks Donkeyote, i have about 25 templates in the worksheet but it only work fine fot the last two templates while the VBA deleted some rows and left others for the other rows. Can you help to look at this.

**DonkeyOte** · 03-13-2009, 11:17 AM

It worked on the test file without incident. If the code does not work on your "real" file then quite plainly you will need to furnish us with another sample file that more accurately reflects your real set-up, perhaps even the real file ? Be sure to strip out any / all sensitive data prior to uploading.