(Solved) – Find the Begin and end Column Using Worksheetfunction INDEX MATCH LOOKUP

  • by
(solved)-–-find-the-begin-and-end-column-using-worksheetfunction-index-match-lookup
For m = 5 To Lastrow
    Cells(m, 46).Value = WorksheetFunction.Index(Range("J" & m & ":" & "V" & m), WorksheetFunction.Match(Range("J" & m & ":" & "V" & m), 0))
    Cells(m, 47).Value = WorksheetFunction.Lookup(2, 1 / (Range("J" & m & ":" & "V" & m)), Range("J" & m & ":" & "V" & m))
Next m

May i know where is the problem from the code?

Leave a Reply

Your email address will not be published. Required fields are marked *