Macro to delete rows containing duplicate headings from row 2 onwards

**Howardc1001** · 05-25-2020, 10:00 PM

I have written code to delete duplicate headings from row 2 onwards on all sheets from "Consolidated Data"

I get a compile error 'End with without With

It would be appreciated if someone could assist me in resolving this

Please Login or Register  to view this content.

**Eastw00d** · 05-25-2020, 10:37 PM

This is better:

Please Login or Register  to view this content.

Cheers
Erwin

**Howardc1001** · 05-25-2020, 10:46 PM

Thanks for the help, Erwin

**Eastw00d** · 05-25-2020, 10:55 PM

If you would make a little more structure in your coding, you would see this easier.
Thank you for the rep.points

Cheers
Erwin

**Howardc1001** · 05-25-2020, 11:17 PM

Thanks for the tip. It will certainly help

Macro to delete rows containing duplicate headings from row 2 onwards

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete rows containing duplicate headings from row 2 onwards

Re: Macro to delete rows containing duplicate headings from row 2 onwards

Re: Macro to delete rows containing duplicate headings from row 2 onwards

Re: Macro to delete rows containing duplicate headings from row 2 onwards

Re: Macro to delete rows containing duplicate headings from row 2 onwards

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to hide columns where zero in in all rows from row2 onwards

[SOLVED] Macro to delete Duplicate headings on Workbooks in a folder

[SOLVED] Macro to combine duplicate Rows Based on a particular Column to separate INV Headings

VBA Code to delete the duplicate Headings

Macro Delete Duplicate Rows with Exception

Macro to Filter and delete Duplicate rows

Delete duplicate headings

Bookmarks

Bookmarks

Posting Permissions