Results 1 to 3 of 3

No Data selected to parse - Run time error

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2019
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    96

    No Data selected to parse - Run time error

    Hello lads,

    I have faced macro error on below code. Can you able to support on this. Enclosed pictures for you to review

    Sub Weight_loop(Optional w As Worksheet)
        Dim ws As Worksheet
        Dim lRow As Long
        Dim strSearch As String
    
        '~~> Set this to the relevant worksheet
        Set ws = ThisWorkbook.ActiveSheet
    
        '~~> Search Text
        strSearch = "Case Ref:"
        
        Application.ScreenUpdating = False
    
        With ws
            '~~> Remove any filters
            .AutoFilterMode = False
            
            lRow = .Range("A" & .Rows.Count).End(xlUp).Row
    
            With .Range("A10:A" & lRow)
            .AutoFilter Field:=1, Criteria1:="=*" & strSearch & "*"
             .Offset(1, 0).SpecialCells(xlCellTypeVisible).Select
            End With
            Call Packlist_Parts_Weights
    
            '~~> Remove any filters
            .AutoFilterMode = False
        End With
        Application.ScreenUpdating = True
    End SubSub Packlist_Parts_Weights(Optional w As Worksheet)
    '
    ' Last Updated - 27/10/2016 - BO
    '
    
       Dim Rng As Range
       Application.ScreenUpdating = False
       For Each Rng In Selection.Areas
          Rng.TextToColumns Destination:=Rng.Resize(1, 1), DataType:=xlFixedWidth, _
             FieldInfo:=Array(Array(0, 2), Array(12, 2), Array(23, 2), Array( _
             44, 1), Array(56, 1), Array(80, 1), Array(92, 1), Array(104, 1), Array(118, 1)), TrailingMinusNumbers:=True
       Next Rng
       Application.ScreenUpdating = True
    
    End Sub
    Attached Images Attached Images
    Last edited by Pepe Le Mokko; 01-06-2020 at 04:17 AM. Reason: Added code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Runtime/XML Parse Error
    By ADRgenesiscorp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2017, 12:07 PM
  2. Strict Parse Error
    By greyclear in forum Excel General
    Replies: 7
    Last Post: 09-22-2014, 04:16 PM
  3. XML parse error
    By sennett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2013, 07:27 PM
  4. [SOLVED] Parse Error
    By Domski in forum Suggestions for Improvement
    Replies: 6
    Last Post: 03-15-2012, 10:07 AM
  5. Replies: 0
    Last Post: 02-25-2012, 10:54 PM
  6. runtime error "1004", no data selected to parse
    By surgical in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2010, 11:41 AM
  7. VBA - Error Using Mid To Parse A Data (.dat) File
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2006, 10:03 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