Results 1 to 2 of 2

Macro Error 9

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2017
    Location
    Mumbai
    MS-Off Ver
    2013
    Posts
    1

    Post Macro Error 9

    Hi,
    I am getting error 9 while run macro, this coding was some1 else, now that person left organization and I am unable to resolve it, please guide solution
    error line is : -
    Del Worksheets("GTB AUDIT"), "GTB", wb
    addn:
    If h = 1 Then lr = Range("GTB").Rows.Count + 9
    If h = 2 Then lr = Range("NGTB").Rows.Count + 9
    Set Gcell = wb.Sheets(InputSheet).Cells.Find(GetVal(CStr(Area(x, j))))
    GCA = Gcell.Address(ReferenceStyle:=xlA1, _
                    RowAbsolute:=False, ColumnAbsolute:=False)
    Range("B" & lr).Value = i
    Range("C" & lr).Value = "01-" + headers(1, j) + "-" + Year
    'Range("D" & lr).Value = i
    Range("G" & lr).Value = Area(x, 15)
    Range("H" & lr).Value = Area(x, 16)
    Range("I" & lr).Value = Area(x, 14)
    Range("E" & lr).Value = Area(x, 17)
    Range("J" & lr).Value = Now()
    
    wb.Sheets(InputSheet).Range(GCA).Copy Range("D" & lr)
    Range("D" & lr).Font.Size = 9
    Range("D" & lr).Font.Name = "Calibri"
    End If
    nxtc:
    Next j
    Next x
    Erase Area, headers
    nw:
    Next i
    Next h
    Del Worksheets("GTB AUDIT"), "GTB", wb
    Del Worksheets("NOT GTB AUDIT"), "NGTB", wb
    Ordering
    FormatGTB Sects
    FormatNGTB Sects
    wb.Close False
    Application.ScreenUpdating = True
    'ActiveCell.MergeArea.Rows.Count
    End Sub
    Last edited by alansidman; 11-10-2017 at 10:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sort Macro Run-time error '1004': Application/Object-defined error.
    By sam1212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2014, 10:05 AM
  2. MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2014, 11:07 AM
  3. Excel macro (compile error. syntax error.) error
    By salar_younis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2014, 06:11 AM
  4. [SOLVED] Simple Calendar pop up macro --> error Run-time error '424': Object required
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 10:38 AM
  5. Print Macro / module error & Update / Clear Macro error
    By mal.b.graham in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-28-2012, 06:40 PM
  6. [SOLVED] Macro error - Run time error 1004 (App defined/Object Defined error)
    By jlax34 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2012, 03:02 PM
  7. Excel Macro Error - Run time error 1004 - Paste method of worksheet class failed
    By kvflynn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2012, 10:51 AM

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