ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Out of memory error (https://www.excelbanter.com/excel-programming/348069-out-memory-error.html)

funkymonkUK[_84_]

Out of memory error
 

Hi

I got a spreadsheet which is only 1.2 MB and when I copy and paste or
anything else of the sort I get a message that says out of memory.

This spreadsheet has graphs. I thought maybe it was the graphs so I
removed them I still got the error. I ran a macro which looks for links
it found some and removed them. but under links menu (I.e editlinks..)
there is still some links.

I dont know what else is causing the problem. I use this spreadsheet on
a monthly basis but this month it dicided to play up.

I tried to insert a graph and get the same error however when I open
up a new one, I am able to insert graphs into the new spreadsheet
without it coming up with the error

OS: NT 4
Excel 97

Yeah I know but our IT department is really slow so dont say to me that
you need to upgrade hehehehe :) i been telling them for 10 years now.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=493318


ilyaskazi[_100_]

Out of memory error
 

After your code for pasting add this line:


Code
-------------------
Application.CutCopyMode = Fals
-------------------

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=49331


funkymonkUK[_85_]

Out of memory error
 

i am copy and pasting it manuall

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=49331



All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com