Macro code needed to delete unnecessary data after 20 lines

**mohammedfaizal** · 05-16-2013, 08:20 AM

Afternoon guys

I have with me a spreadsheet and after every 20 lines it includes the logo of my company and blank lines

If I want to deletes all the logo's at once, how would i go about coding this?

Thanks
Mo

TEST.docx

**NeedForExcel** · 05-16-2013, 08:22 AM

So if I say, the Macro will delete all the Rows wherein the Cells in Column A & B are not blank, is that OK?

Thank You,

Deep

**mohammedfaizal** · 05-16-2013, 08:27 AM

Hi Deep

I'm not sure I understand, but

What about a code which reads: After every 20 rows , delete the next 4 rows

How does that sound?

**NeedForExcel** · 05-16-2013, 08:32 AM

delete the next 4 rows?

???

**mohammedfaizal** · 05-16-2013, 08:36 AM

I've identified a flaw in that. its not actually 4 rows

But Is there any other way of solving this?

Macro code needed to delete unnecessary data after 20 lines

LinkBack

Thread Tools

Rate This Thread

Display

Macro code needed to delete unnecessary data after 20 lines

Re: Macro code needed to delete unnecessary data after 20 lines

Re: Macro code needed to delete unnecessary data after 20 lines

Re: Macro code needed to delete unnecessary data after 20 lines

Re: Macro code needed to delete unnecessary data after 20 lines

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions