memory

Hi all, I have an unusual VBA Out of Memory Error. I have a spreadsheet which I have restored from backup, which opens fine, behaves fine, and does all it should (it contains about 10 modules, none of which is bigger than 64kb). It contains a couple of very small forms. It also contains about...

Hi guys. I did google this, at length, and found the answers not that helpful. Just FYI. ;) I have a vba module thats about 28 pages long. There are 5 of these modules. Each module has around 100 declared variables. I need to add more. About 10 more to each. When I try to add more using...

Hi, I have an excel database worksheet and occupied 65,000 rows and 15 columns.Column A had this formula (=IF(COUNTIF(B:B,B7)>1, "Duplicate!","Not Duplicate")), Column B had this forumula (=CONCATENATE(SUBSTITUTE(SUBSTITUTE(C2,",",".")," ",""),D2,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G2,",",""),"...

Hi each sheet in excel 2010 has 1M rows and 16K rows. If I open a sheet, are all columns and rows are open (saved in computer memory)? or excel opens few only and it will open more as we screw down. What i mean by open, is to create or reserve line in the memory of the computer. because 16B...

I have recently upgraded my system to High Sierra only for my XSLM file, which is 3.7 MB in size, to stop saving with the above message. I get this message even if I go in and then try and save the program without changing anything. If I leave the file open, the message comes up following by the...

Hello everyone, I have a minor issue that I tried to look up on google. I have a out of memory error when trying to access my macro, I read that I might have too many useless lines in my macro but the problem is I cannot access at all the macro hence I cannot modify the code. Can anyone...

I have the following macro in excel: Sub Analyze() ' , ' ; - ! LR = Application.WorksheetFunction.CountA(Sheets("Address Original").Range("A:A")) k = 2 Sheets("Errors").Range("A2:N1000000").ClearContents For i = 2 To LR c = "" For j = 1 To 13 c1 = 0 c2 = 0 c3 = 0 c4 = 0 c5 = 0 c6 = 0 c7 = 0...

Morning all, I've designed a program to open a workbook on a memory stick however currently it has to be plugged into the E: is there any way for the program to detect which port the memory stick is in? Any help would be appreciated, Thanks in advance

Hello Geniuses, I need clarification to which variable types to use: Integer vs Long. When do I use long? I am confused. I am thinking maybe where I have used long, I may be using Integer instead. Thanks in advance. Kelly. PS. Also when I declare almost all my variables at the top of my...

Good morning. Ive been creating a couple of userforms and I notice that when I test all functions and changes I make I keep getting this error "out of memory" in my excel . I think the userforms are the issue. Typically during testing , the userforms are loaded and unloaded a ton of times...

hello excelers, those 70 excel files are heavy files, I successfully open 21 excel files, but on the 22 file - it won't open, just give an error with headline "Microsoft visual basic for application" and says "out of memory", which is logic, I've seen I can really work on those 21 files...

Hi Please assist am getting Run time error 7 out of memory below red marked. .TextFilePlatform = 437 .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .Refresh BackgroundQuery:=False

Hi, I have a workbook with multiple sheets with the data around 4 lacs in each sheet, and from vba I am manipulating sheets data, like filling the value in cells or deleting the rows etc and also applying index match formula from VBA. sheet1:- 40000 rows data with column customer_id sheet2:-...

When I run macro VB Editor says "Out of Memory". But when I restarted the file it worked. I Use Window 7, And MSOffice 2007. How to Fix this. Thanks in Advance.

Do anyone know how I can simplify this codes???? Private Sub CommandButton2_Click()'Declare the variables Dim AddData As Range, Current As Range Dim user As Variant, Code As Variant Dim PName As Variant, AName As Variant Dim ws As Worksheet, ws2 As Worksheet, ws3 As Worksheet Dim result As...

Hi All, I am getting the following message, "Excel can not complete this task with available resources. Choose less data or close other applications." And when I click OK, I get the following message box. Microsoft Excel cannot open or save any more documents because there is not enough...

OS X Yosemite 10.10.5 Excel 2011 version 14.7.2 (170228) on MAC Am running the below macros in module 4 as an end of month worksheet cleanup, and have been getting "Out of Memory" messages. How can this be fixed? Sub ClearCheckbookEntries() Range("V5:Y54,AB5:AE54").Select...

Hi everyone, I am new to this forum but have been reading a large number of posts recently as I am currently self teaching VBA for use at work! I currently am having an issue with a bit of code that I have created. The aim of the code is to autofilter multiple sheets depending on a cell value...

Pretty simple code. I have daily files (dy and mo) for multiple years (yr) for different areas (ucode) that are in .txt format. I want them in excel so that I can use them later for other vba macros. So there are four "For" loops, then I declare the file name and the path name. When the...

I am trying to create a pivot table for around 600,000 rows after merging data over several tabs into one worksheet using this vba code: Sub PivotTableLoop() Dim WS_Count As Integer Dim I As Integer Dim LastRow As Long ' Copy first set of data from tab Month_12 - Start of Financial Year...