Custom Number Fomatting Memory Issues

B

Boone

I have a macro that creates lots of different custom
number formats. After about 300, I am thrown an error
saying no more custom number formats can be created. I
have searched online and it says that the quantity of
available custom number formats is "Limited by available
memory." My computer has plenty of free memory, so I
assume excel doesn't have enough memory allocated. Any
Idea on how to increase the memory available for this, or
get around it in any other way? Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top