Results 1 to 27 of 27

Excel 2013 keep crashing when i run macro

Threaded View

fluffyvampirekitten Excel 2013 keep crashing when... 07-06-2015, 01:27 AM
Keebellah Re: Excel 2013 keep crashing... 07-06-2015, 02:38 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-06-2015, 05:27 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-06-2015, 05:45 AM
Keebellah Re: Excel 2013 keep crashing... 07-06-2015, 06:40 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-06-2015, 09:03 PM
humdingaling Re: Excel 2013 keep crashing... 07-06-2015, 09:30 PM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-06-2015, 11:59 PM
humdingaling Re: Excel 2013 keep crashing... 07-07-2015, 12:17 AM
humdingaling Re: Excel 2013 keep crashing... 07-06-2015, 09:37 PM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-06-2015, 11:51 PM
humdingaling Re: Excel 2013 keep crashing... 07-07-2015, 12:08 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-07-2015, 01:51 AM
humdingaling Re: Excel 2013 keep crashing... 07-07-2015, 12:31 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-07-2015, 02:03 AM
protonLeah Re: Excel 2013 keep crashing... 07-07-2015, 12:51 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-07-2015, 01:51 AM
humdingaling Re: Excel 2013 keep crashing... 07-07-2015, 02:15 AM
humdingaling Re: Excel 2013 keep crashing... 07-07-2015, 02:20 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-07-2015, 02:38 AM
humdingaling Re: Excel 2013 keep crashing... 07-07-2015, 02:18 AM
humdingaling Re: Excel 2013 keep crashing... 07-07-2015, 02:48 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-07-2015, 03:06 AM
Keebellah Re: Excel 2013 keep crashing... 07-07-2015, 03:00 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-07-2015, 03:11 AM
Keebellah Re: Excel 2013 keep crashing... 07-07-2015, 03:20 AM
fluffyvampirekitten Re: Excel 2013 keep crashing... 07-07-2015, 03:25 AM
  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    66

    Unhappy Excel 2013 keep crashing when i run macro

    My excel 2013 keep crashing whenever i run this macro .
    Is there something wrong with my code that crashes my excel .
    Please help ,thank you

    Private Sub Missing_UserName_Dept()
    
    ' Update User Name and Dept from Missing User name & dept xlsx file
    
    Dim MaxRowNum, RowNum As Integer
    
    Sheets("Simpat").Select
    
    
    'Counting number of rows / Find the max number of row
        MaxRowNum = 1
            
        Do While Cells(MaxRowNum, 2) <> "" Or Cells(MaxRowNum + 1, 2) <> ""
            MaxRowNum = MaxRowNum + 1
        Loop
        
    
    'Find the row with the USERNAME & DEPT - "NOT INDICATED" and use a vlookup Function
    
    RowNum = 1
    Do While RowNum < MaxRowNum
    
    If UCase(Cells(RowNum, 16)) Like "*NOT INDICATED*" Or UCase(Cells(RowNum, 17)) Like "*NOT INDICATED*" Then
    
    
    'Vlookup User Name from the file MISSINGUSERNAMEDEPT.xlsx
    Range("P3").FormulaR1C1 = "= VLOOKUP(C[-3],MISSINGUSERNAMEDEPT.xlsx!R1:R1048576,2,0)"
    
    'Vlookup Dept from the file MISSINGUSERNAMEDEPT.xlsx
    
    Range("Q3").FormulaR1C1 = "= VLOOKUP(C[-4],MISSINGUSERNAMEDEPT.xlsx!R1:R1048576,3,0)"
    
    'AutoFill formula. Copy and paste data as value
        Range("P3:Q3").Select
        Selection.AutoFill Destination:=Range("P3:Q " & MaxRowNum), Type:=xlFillDefault
    
    
    'Copy and paste data as Value
        Columns("P:Q").Select
        Selection.Copy
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        
        Application.CutCopyMode = False
    
    
    End If
    Loop
    
        Range("P3").Select
        
    End Sub
    Last edited by fluffyvampirekitten; 07-06-2015 at 06:00 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Custom cell formatting crashing Excel 2013
    By rpdhuk in forum Excel General
    Replies: 1
    Last Post: 06-23-2015, 12:29 PM
  2. VBA code causing memory leak. Crashing Excel 2013/64. Please help.
    By kabammi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2015, 11:19 PM
  3. Macros crashing Excel 2013
    By Thor42 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2015, 05:13 PM
  4. Excel 2013 Crashing on opening a XLSM file
    By Wongadob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2014, 05:10 AM
  5. Replies: 3
    Last Post: 07-20-2014, 11:46 AM

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