Change Event Code too long - Need to combine 2 events into 1 macro

**Sc0tt1e** · 10-15-2014, 01:34 AM

Please Login or Register  to view this content.

The above values in rng1 is the max amount of cell values I can have in the macro before I get a run time 1004 error. I still have the below values to add, is there anyway of creating a rng2 with these values to run within the change sub as I am unable to combine these values within a working macro?

Please Login or Register  to view this content.

**karedog** · 10-15-2014, 03:22 AM

Hi,

You can use matrix and loop like this

Please Login or Register  to view this content.

**Sc0tt1e** · 10-15-2014, 03:36 AM

Matrix is new to me but it does the job, thank you karedog

**karedog** · 10-15-2014, 03:57 AM

You're welcome Sc0tt1e, thanks for the reputation point.

Change Event Code too long - Need to combine 2 events into 1 macro

LinkBack

Thread Tools

Rate This Thread

Display

Change Event Code too long - Need to combine 2 events into 1 macro

Re: Change Event Code too long - Need to combine 2 events into 1 macro

Re: Change Event Code too long - Need to combine 2 events into 1 macro

Re: Change Event Code too long - Need to combine 2 events into 1 macro

Thread Information

Users Browsing this Thread

Similar Threads

Best way to combine to worksheet change events

[SOLVED] Code working as change event, but not as a macro.

Combine 2 worksheet change events

Request macro code - when cell change event

[SOLVED] combobox change event is running when enable events is false

Bookmarks

Bookmarks

Posting Permissions