Runtime Error 28 - Out of Stack Space

Hi,

So after managing to get this to run when shared, occasionally we are seeing runtime error 28 out of stack space. i have learnt a lot over the last few weeks on VBA, and my knowledge is getting better, i know this code is not the most efficient, so is likely the reason for error 28. if anyone can help on the cause.

Im happy to post a workbook if needed, but dont see it will have any further benefits, i have not posted anywhere else yet, hopefully can be answered here.

Names and network references have been changed / removed.

Due to Char limit spread over two posts.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

@Aligw, if you read the first post it says due to Char limit spread over two posts, hence the second post, this is not solved.

It means you have too many variables, and/or calling too many functions/subroutines.

I would look at incorporating the use of dictionaries and arrays to manage your use of variables.

Thanks @JohnTopley fixed a couple of errors but so far touch weed seems great and a lot faster. so fingers crossed.

@JohnTopley yes that works so thank you very much, not sure where weed came from haha.

I would be interested in the further tidying up, but would also be interested in understand it to. Anything that can make it less buggy, error checking, and of course quick.

Thanks

@JohnTopley im also working on another project which some of the above would be very good for, is it possible to copy just two columns say A and C ? then put on another sheet as A and B, i tried this but ended up with it in A and C and B was blank.

Thanks

ill give this a try