Adding a variable returns error

[mikeymay]

I am trying to add a variable to a routine but VB won't let me add it and returns an 'Out of Memory' error and removes the variable.

Not entirely sure why it's doing this as I don't have a massive number of public or local variables declared and the module isn't especially large.

I am setting a lot of range variables to manipulate data and move around various sheets without having to activate the relevant sheets and I'm wondering of this is causing a problem. I have, as far as I can see, set all range variables to 'Nothing' when finished with, but when set to 'Nothing' some will be re-used again as part of a loop routine.


Thanks

 

[mikeymay]

This is frustrating - I can't even remove variables (currBudgetMonth1-12) to replace with the array Nories suggested.

Could it be something to do with a corrupted dll file somewhere? I have read this might be an issue with these errors?

 

[RoryA]

Are you saying that the error occurs whilst adding the code, and not while running it?

 

[mikeymay]

Yes. When I tried to add another variable (Dim variable as variable type) I get the out of memory messgae and removes the text I typed in

 

[RoryA]

Can you add code to a different module?

 

[mikeymay]

I am just in the process of moving the code and the worksheets to a new workbook and this seems to be working. I moved the code into a new book and I could add code to it.

I'm thining maybe the file has somehow become corrupted but will let you know once I have moved everythign over and tested.

 

[mikeymay]

Ok, I have moved all the code and the worksheets to a new file and this seems to have worked.

Thinking about it, I intially encountered an error where a file I was saving via the code had a folder & file name of more than 218 characters which it the limit apparently. After this I then started to encounter the out of memory problems.

I'm not sure if have the '&' character as part of string variables could be an issue as I have come across problems with this character before, and I am using this in some of the string variables.

 

[Norie]

I was going to suggest a corrupt file but didn't want to be pessimistic.

I wouldn't think & being part of a string would be a problem, as long as it was meant to be in the string.

 

[mikeymay]

The '&' character does cause an issue where a string variable that contains it is used to name a file, the '&' is removed from the file name when saving to a temp folder before being attahced to an email.

I have a work around to deal with this but thought it may have had something to do with it.