Results 1 to 4 of 4

Runtime error 7 out of memory vba apple mac

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2016
    Location
    Argentina
    MS-Off Ver
    2011
    Posts
    7

    Runtime error 7 out of memory vba apple mac

    I have this macro:

    Sub Filtro()
    
    NumRow = Application.WorksheetFunction.CountA(ActiveSheet.Range("D:D"))
    VolumeSum = Application.WorksheetFunction.Sum(ActiveSheet.Range("E:E"))
    Dim Cuadro As Range
    Set Cuadro = ThisWorkbook.ActiveSheet.Range("D15").CurrentRegion
    
    Tiempo = Now
    
    J = 0
    
    'Proceso de borrado de filas
    For I = 2 To NumRow
        If IsEmpty(Cuadro(I, 1)) Then Exit For
        J = J + 1
            For Each Filtro1 In Sheets("Filtro").Range("A2:A60000")
            If IsEmpty(Filtro1) Then Exit For
            If InStr(1, Cuadro(I, 1), Filtro1, vbTextCompare) <> 0 Then
            I = I - 1
            Cuadro(I + 1, 1).EntireRow.Delete
            End If
        Next
        Application.StatusBar = "Queries procesadas: " & J & " de " & NumRow - 5 & "."
        DoEvents
    Next I
    
    
    
    Application.StatusBar = False
    
    'Mensaje
    MsgBox "Quedaron " & NumRow2 - 5 & " queries, se eliminaron " & Worksheets("Registro").Range("B3").Value & ". Filtro hecho en " & Format(Now - Tiempo, "hh:mm:ss")
    
    End Sub
    When i use this macro on my desktop computer it works really well, but not in the MacBook Air.

    Any ideas of what is going on with the code or why the mac run out of memory?

    Thanks a lot!

    Upon review, it is noted that although the member's question is the same, the code is completely different so this is not a duplicate. I have re-opened the thread. --6StringJazzer
    Last edited by 6StringJazzer; 08-29-2016 at 02:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Runtime error 7 out of memory vba apple mac
    By ezetalamona in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2016, 01:21 PM
  2. [SOLVED] How do I convert text ie apple to string "apple" in excel or VBA?
    By dav_mark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2013, 06:05 PM
  3. Replies: 1
    Last Post: 12-08-2011, 08:52 AM
  4. runtime error “out of memory”+excel macro
    By bhavin12300 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-11-2010, 02:25 AM
  5. [SOLVED] Runtime Error "7": Out of Memory
    By Run Time Error "7" in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2005, 08:10 AM
  6. [SOLVED] How to handle error 8007000e Memory Error
    By L. A. M. in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-27-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1