kestrel1306
01-17-2022, 12:41 PM
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
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