Run Time Error 1004 - Selection too Large

**sgedo** · 04-01-2009, 05:54 AM

Hi All,

I am a noob with marco so please bear with my question or lack of knowledge.

I have a macro that runs on a command button. When I click the button, it works fine to up to ~2500 rows but if I were to increase the values I get a 'Run Time Error 1004, selection too large.

The code is as follows:-

Please Login or Register  to view this content.

When I go into debug mode, it is highlighting on the line ActiveSheet.PasteLink.

Any ideas anyone?

**mudraker** · 04-01-2009, 06:37 AM

Welcome to Exceltip forum

Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)

**sgedo** · 04-01-2009, 11:57 AM

Thanks for the links mudraker

**shg** · 04-01-2009, 12:17 PM

Please Login or Register  to view this content.

doesn't appear in your code.

Try this:

Please Login or Register  to view this content.

**sgedo** · 04-01-2009, 09:43 PM

Shg,

Thanks for the codes but I still get the same error (Selection too large) if I were to load/check enteries more than 3000.

When I debug the stops at the following line.

Please Login or Register  to view this content.

**shg** · 04-01-2009, 10:27 PM

What's the value of RowDepth when it fails?

**sgedo** · 04-01-2009, 10:47 PM

shg, the number I tested is about 2733 before I get the error message.

Run Time Error 1004 - Selection too Large

LinkBack

Thread Tools

Rate This Thread

Display

Run Time Error 1004 - Selection too Large

Re: Run Time Error 1004 - Selection too Large

Re: Run Time Error 1004 - Selection too Large

Re: Run Time Error 1004 - Selection too Large

Re: Run Time Error 1004 - Selection too Large

Re: Run Time Error 1004 - Selection too Large

Re: Run Time Error 1004 - Selection too Large

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions