Run-time error '1004': Delete method of Range class failed

**Lozza1234** · 07-17-2014, 05:59 AM

I am trying to delete rows that DON'T contain certain names, the code I currently have is:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The issue is that when I run this code it gets to the end and succesfully deletes the unwanted rows but then comes up with an error :

Run-time error '1004': Delete method of Range class failed

If i choose to debug it highlights the following code:

Please Login or Register  to view this content.

I can't work out what the problem is, if i remove the NOT from the code and make it delete the rows i wish to keep the code works perfectly fine.

If anyone has any ideas that would be great!!

**Richard Buttrey** · 07-17-2014, 06:32 AM

Hi,

Personally I'd avoid a looping procedure to do this sort of stuff. Using a Data filter is the fastest way I know and far more efficient than a loop.

So set up a horizontal criteria list with your consultant names and name this range say "crit". Put ="<>John Smith" etc. in the second row of the criteria. Name the range you're trying to filter 'Data"

Then something like

Please Login or Register  to view this content.

**Lozza1234** · 07-17-2014, 06:59 AM

Thanks for you help, but i dont really understand what you mean by a horizontal criteria list. Could you please explain a little more?

**Richard Buttrey** · 07-17-2014, 04:56 PM

Hi,

I simply mean put the column label of the column that contains the consultant names in say cells A1:I1 (i.e. nine cells) and then in
A2 put <>John Smith
B2 put <>Juilian Den
...etc

and name A1:I2 'Crit'

Run-time error '1004': Delete method of Range class failed

LinkBack

Thread Tools

Rate This Thread

Display

Run-time error '1004': Delete method of Range class failed

Re: Run-time error '1004': Delete method of Range class failed

Re: Run-time error '1004': Delete method of Range class failed

Re: Run-time error '1004': Delete method of Range class failed

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Run Time Error '1004': Select method of Range Class failed VBA

Getting Run-time 1004 Delete Method of Range Class Failed with Two Macros active together

[SOLVED] Run-time error '1004' ; Delete method of Range Class failed

[SOLVED] Delete method of range class failed - run time error 1004

Run-time error '1004' - Select method of Range class failed

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions