out of memory

  1. T

    "Compile Error: Out of memory" with complex userform and many vba subroutines

    I have a spreadsheet with a fairly complex userform that acts as a UI. I believe the issue is caused by the ammount of controls i have on my userform as it was working fine upto a point. I have already upgraded from 32 bit excel to 64 which solved the issue at an earlier stage when i had less...
  2. N

    "Out of memory" error with userform

    I am creating a userform for my organization which has multipage controls on it, and many controls within each multipage. I had been working on getting the userform completed until I ran into an "Out of memory" error. This happens on a fresh restart of my computer and with no other programs...
  3. V

    How to clear out cache

    I'm getting this problem "OUT OF MEMORY", when I run my vba. My vba basically takes various things from a online csv which grabs time, year, # of ad clicks, weather, and, it takes it from there and pastes it into my document every 5 seconds or so. So I have an up-to-date dashboard of...
  4. I

    7: out of memory

    Hi When I click button to generate report there is the 7 out of memory error popup Private Sub btn_Click() On Error GoTo ErrCheck Dim strPeriod As String Dim intFY As Integer Dim strFMth As String Dim cnt As New ADODB.Connection Dim rst As ADODB.Recordset Dim...
  5. I

    7: Out of memory (Codes provided)

    WHEN click a button in Access, which suppose to generate an excel report normally. But this time it shows error 7: Out of memory Private Sub btn_Click() On Error GoTo ErrCheck Dim strPeriod As String Dim intFY As Integer Dim strFMth As String Dim cnt As New ADODB.Connection...
  6. I

    Runtime error Out of Memory

    Beginner VBA user here. I'm getting a runtime error that says "Out of Memory" with one certain set of code. I have one specific worksheet within a workbook that contains 4 rows each valued as the days Monday, Tuesday, Wednesday, Thursday respectively in Column "A". The nature of the worksheet...
  7. K

    Excel VBA - Run Time Error 7 - Out of memory

    Hi, I keep getting Run Time Error 7 - Out of Memory in the following code: Sub PDFandValueVersion() ' This bit of code will select the worksheets to be PDF'd Dim rng As Range For Each rng In Sheets("Config").Range("A1:A" & Sheets("Config").Range("A" &...
  8. F

    Eliminate out of memory

    Hi, let say I have code: Dim L1 as Long, Dim L2 as Long Dim L3 as Long, Dim L4 as Long Dim L5 as Long, Dim L6 as Long Dim sum_L as Long L1 = 1 L2 = 100 L3 = 10000 L4 = 1000000 L5 = 100000000 L6 = 10000000000 sum_L = L1+L2+L3+L4+L5+L6 'error when I try to add above value, I got error...
  9. L

    Out of memory when deleting rows

    I try to run the VBA code below to delete all of the rows is the range row 12-100 what are empty in the C column. Anyhow I get "out of memory" error when running this. Any idea about why? For i = 100 To 12 Step -1 If Cells(i, 3) = "" Or Cells(i, 3) = "Name" Then...
  10. A

    Excel Fuzzy Lookup Add-in - Exception out of memory

    I have been using Fuzzy Lookup for a while to match 2 lists with no problems. Just recently I have started to experience an error that return the following exception - Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib) I am not sure if it's caused bu the volume of the...
  11. J

    VBA code error: out of memory

    Hi all, I am a newbie to VBA> Im am trying to write a code that uses an autofilter to help me select and copy groups (Joey, Cub, Scout, Venturer, Rover, Leader) from my main worksheet ("ALL") and paste the data associated with the group onto a separate worksheet (named after the group) in the...
  12. S

    Facing "out of memory" issue while importing data from a .csv file to create Pivot Cache

    Hi All, I need a help on this issue which we are facing. We are trying to create pivot cache from an external .csv file. This works fine when the csv file is small (<500 mb). But it given "out of memory" error for bigger .csv files(>~500 mb). Attaching sample code for reference - Dim...
  13. R

    Out of Memory VBA error

    I have two spreadsheets that when I open and do much of anything to, I get a VBA error that says "Out of Memory" and then I have to click ok about 10 times before it goes away. Every couple of times it causes excel to crash. The file is not full of data or overly complicated macros, so I...
  14. S

    Out of Memory error while adding a new line of text

    Hi, I have a long excel sub routine which makes database calls to MS Access almost 25-30 times. I actually have to query the data and then process, which I am doing it in a separate sheet. Then I display the processed data in the active sheet. I want to add another function call in the code...
  15. D

    Excel out of memory

    I've created a VBA process that opens an Excel template file, populates it with data from a server, saves, prints and closes the file. This process works flawlessly when executed from a menu by a user, but I have been asked to automate it to create a series of reports. To do this, I open a...
  16. T

    Compile Error : Out of Memory - Only in Win 7 and not XP

    Hi All, Problem Summary : My code runs successfully in Windows XP machine, but the same code gives me Compile Error : Out of memory while running on a Windows 7 machine Purpose of the code : It is sort of a report generation code where the user can export customized data to a new file...
  17. B

    Out of Memory Error

    Hello All, So I've created a form that has literally 1200 Textboxes. After creating this, I tried to access the code, but when I attempted to do so I got a message prompt that says "out of memory". This prompt also occurs when I try to compile and run the form. Is there a way around this...
  18. M

    Run-time error '7' Out of memory Excel 2007

    I have seen this error referred to many times in forums but they all seem to involve multiple, large workbooks and moving data between them. I get this problem with a single (though quite large: ~60 Mega Bytes) workbook. My code is below. It just takes the ChartTitle, does some minor string...
  19. D

    Text To Columns Macro (to avoid out of memory error)

    I am trying to convert cells (all in column D) which are separated by "~" into columns. Unfortunately, running the text to columns command on several rows at a time can cause Excel to panic with an out of memory error (error #7 etc.). The file is ~100mb and contains 500k-700k rows (I have 4GB...
  20. M

    Out of memory

    Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am busy bodily creating loads and loads of reports statistics on multiple worksheet. At one time I am even going through a large loop creating 30-40 worksheets i.e. for all business...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back