Results 1 to 9 of 9

Error 438 - selection.bug

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2022
    Location
    Lisbon
    MS-Off Ver
    365
    Posts
    4

    Error 438 - selection.bug

    Hello Guys,

    I need your help. I was running my macro without problems (I was using Excel 2013 and now company changed to Excel 365) and I am getting this error 438 on the following line:
    Sub add_IFS_data_and_volume()
    
    Dim IFS_row_count, eP_number, Last_row As Long
    Dim Sheet_name As String
        
        Application.Calculation = xlCalculationManual
        
        Worksheets("IFS").Select
        On Error Resume Next
        ActiveSheet.ShowAllData
        On Error GoTo 0 ' re-activate error message
        Columns("N:N").Select
        Selection.NumberFormat = "0"
    
        Worksheets("Overview").Select
        i = Worksheets("Overview").Cells(2, 3).End(xlDown).Row
        
        For j = 3 To i
    '        If Cells(j, 3).Value = 28077 Then Selection.bug
            Application.StatusBar = j & "/" & i
            Worksheets("Overview").Select
            Cells(j, 5).Select
            If Cells(j, 48).Value <> 0 And Cells(j, 103).Value = 1 And Cells(j, 5).Hyperlinks.Count > 0 Then
                IFS_row_count = Cells(j, 48).Value
                eP_number = Cells(j, 3)
                Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    
     Sheet_name = ActiveSheet.Name
    '            If Sheet_name = "28077" Then Selection.bug
                
                If ActiveSheet.Name = "Overview" Then Selection.bug (MISTAKE HERE)
                'delete old IFS value
                For m = 1 To 200
    Can you please let me know what I can do to correct this mistake ?

    Thank you
    Last edited by AliGW; 01-10-2022 at 07:00 AM. Reason: Code tags added. Please read our rules as soon as possible!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] sort by selection vba error
    By bob33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2017, 12:41 PM
  2. Selection error
    By Mantask in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-23-2015, 01:14 PM
  3. range selection error
    By daniva92 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 10:32 AM
  4. Selection.AutoFill error
    By Dabooj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2008, 12:26 PM
  5. error 91 with selection
    By Reinder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2007, 03:41 AM
  6. [SOLVED] Selection Error
    By cheungm@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2006, 04:43 PM
  7. Selection.Sort error
    By Krager in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2005, 02:05 PM

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