+ Reply to Thread
Results 1 to 2 of 2

Run-time error '28' Out of stack space

  1. #1
    Registered User
    Join Date
    06-17-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Run-time error '28' Out of stack space

    Hi All,

    I created a spreadsheet in excel 2013 and had no issues with the code i created. when i try to run it i get the error code '28' and i have no idea to solve this.

    PHP Code: 
    Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal A_Scound As Long)

    Public 
    Sub ScheduleJoodi_API()
        
    ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
        DoEvents
        Sleep 
    (100)
        
    ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
        Joodi
    Exit Sub
    End Sub


    Sub Joodi
    ()
        If 
    Sheet1.Range("A1").Value 1 Then
        Application
    .Calculation False
        Sheet1
    .Range("A2:A4").Copy
        Sheet1
    .Range("B2").PasteSpecial Paste:=xlPasteValuesOperation:=xlNoneSkipBlanks:=FalseTranspose:=False
        Application
    .CutCopyMode False
        Range
    ("B1").Select
        Application
    .Calculation True
     End 
    If
        
    Call ScheduleJoodi_API
    End Sub 
    If anyone could help out it would be greatly appreciated.

    Thanks in advance,

    Alex

  2. #2
    Registered User
    Join Date
    06-17-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Run-time error '28' Out of stack space



    any thought

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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