Overflow Runtime Error 6

**xjohnson** · 11-04-2018, 08:14 AM

Hello,

When I try to select all on a sheet by clicking the upper left box I get this error. Does anyone know why and how to fix please?

Thank you

debug at:

If (Sh.Index < 4) + (Target.Count > 1) Then Exit Sub

Please Login or Register  to view this content.

**6StringJazzer** · 11-04-2018, 09:19 AM

If you select the upper corner to select the entire sheet, you are selecting 1,048,576 rows x 16,384 columns, which is over 17 billion; Count has a limit of around 2 billion.

Use Target.CountLarge instead.

**xjohnson** · 11-04-2018, 09:22 AM

Thanks Jeff that worked!

Overflow Runtime Error 6

LinkBack

Thread Tools

Rate This Thread

Display

Overflow Runtime Error 6

Re: Overflow Runtime Error 6

Re: Overflow Runtime Error 6

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Runtime error 6: Overflow

runtime error 6 overflow??

[SOLVED] Runtime error 6 - Overflow

Runtime Error 6 Overflow

[SOLVED] VBA runtime error '6': Overflow

[SOLVED] Overflow Runtime error 6

Runtime Error 6 Overflow

Bookmarks

Bookmarks

Posting Permissions