Not enough memory error - Can't open file
I have an Excel 2000 file in which I created a very long macro that basically
copies indiviudal cells from one worksheet into another changing structure of
the data basically. It worked fine when I ran it against 3 files I needed to
copy the data from. When I tried to do a 4th file of the exact same format I
got the not enough memory error. I shut down excel and the computer but I
still get the error and can't open the macro file . Am I screwed? Or is there
a way for me to retrieve - get my macro back so I can try modifying it or my
process so I don't have this problem again.
Thanks
John
|