compile error 'out of memory' 1

[jupops]

Good Morning All

Just a quick question, if anybody could help? When compiling some vba code, I get the message 'out of memory'. This is when I set up an array from a text document, using delimited option and setting tab and comma to true.

Thank you.

Regards

Jupops

 

[senators40]

Microsoft only had a certain amount of kb per sub and per if statement. It is possible that you have too much information in the sub statement.

The sheet should show you where it stops. Before that point enter the following assuming Macro2 is the next macro

Application.Run ("Macro2&quot

Copy the information from where it stops to the end of the macro to the new Macro "macro2"

Hope it helps

Jeff

 

[jupops]

Thank You

This is great

Jupops