Hello team VBA,

I have an issue with a procedure thats too large.

Within my wee "app" there are a few related procedures that I use as a almost a database, with just under a 1,000 items.

Problem is that I've essentially run out of room to add more stuff.

I've tried simply splitting it into smaller chunks but it errors out.


With Data2
.Data_2_stuff = "text"
.Data_2_more_stuff = "more text"
End With
Adddata2 Data2

Any ideas would be great thanks, as I need to add more elements.

I have previously split it up, which is how I wound up with #2, I dont really want to split it again...

Regards
Kes