Adding wider range to VBA code gives error 1004

**Christianekstrom** · 12-01-2021, 05:46 AM

Hey all!

Having trouble with my VBA code which is used to clear the contents of a specific range of cells. It works well up to a specific range, but when I add another one it gives me "Runt-time error '1004': Method 'Range' of object '_Global' failed".

This is my code when it is working:

Please Login or Register  to view this content.

As soon as I add the range E175:W178 it gives me the error

**mohadin** · 12-01-2021, 06:08 AM

Hi
Try some thing like this

Please Login or Register  to view this content.

**PrizeGotti** · 12-01-2021, 06:20 AM

I'm not entirely sure why that happens, I tried myself and found the same issue.

However, this code should do the same trick;

Please Login or Register  to view this content.

**mohadin** · 12-01-2021, 06:33 AM

Ok
BUT what about speed?

**romperstomper** · 12-01-2021, 07:30 AM

Originally Posted by PrizeGotti

I'm not entirely sure why that happens

The range property is limited to an argument of 255 characters at most. In the working code, it's at 253, so adding the additional range takes it over that limit.

**PrizeGotti** · 12-01-2021, 07:36 AM

Originally Posted by mohadin

Ok
BUT what about speed?

Not entirely sure what you mean? Either way completes in well under a second.

**Christianekstrom** · 12-02-2021, 03:33 AM

Originally Posted by PrizeGotti

I'm not entirely sure why that happens, I tried myself and found the same issue.

However, this code should do the same trick;

Please Login or Register  to view this content.

Thanks alot that worked well!

Adding wider range to VBA code gives error 1004

LinkBack

Thread Tools

Rate This Thread

Display

Adding wider range to VBA code gives error 1004

Re: Adding wider range to VBA code gives error 1004

Re: Adding wider range to VBA code gives error 1004

Re: Adding wider range to VBA code gives error 1004

Re: Adding wider range to VBA code gives error 1004

Re: Adding wider range to VBA code gives error 1004

Re: Adding wider range to VBA code gives error 1004

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Run-time Error 1004, delete method of range class failed? (Code included)

Run-time error '1004': Method Range of object_Worksheet Failed (because of wrong code)

[SOLVED] Runtime error 1004 range of object with VBA code for copying all worksheets to word

Help with VBA Code...error = run time error 1004 autofilter method of range class failed

VBA Code...error = run time error 1004 autofilter method of range class failed

[SOLVED] Range error in code, runs alone but not inside my full program, giving runtime error 1004

Adding library references with code -> error 1004

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions