Public variables

I have a sheet with quite a few variables publicly defined in the macro. We have also been experiencing some issues with other sheets opening slowly. The below is the list of these variables by type

Integer 23
Long 1
Name 1
Range 4
String 33
Variant 17
Worksheets 1
Date 4
1D array 1
2D array 1

The two arrays are not very large arrays.

Is this likely that this many public variables would be the cause an issue? Or is this not too many? Is there a limit?

Marvin,

there are quite a few formula but It doesn't seem to be a calculations issue. Causing recalculation takes basically no time at all.

the symptoms I'm trying to diagnose are that it seems to be less stable (it crashes with the out of memory VBA message sometimes although I seem to be the only one getting that at the moment) and a user was complaining that it was slow to open their CSV files while it was open.

I expect it is pretty hard to diagnose the issue. If we can say it is unlikely to be the variables that is useful to know and I wont bother going through the process of trying to redesign that part of the code.

You can use more public variables. In your case may be you are having some other issues. But it is tough to say without seeing the file.

Thanks for that Marvin,
That may well be a factor in this.