fixed
Sub Select_Bulk_Data_InputBox_Final2() Dim sheetName As String sheetName = "Data 1" ' <<-- Change the sheet name here only (exact name) Dim wb As Workbook Dim ws As Worksheet Dim rng As Range Dim inputData As String Dim arrInput As Variant Dim searchValues() As String Dim cleanedValues() As String Dim removeChars As String Dim arrRemove As Variant Dim removeProvided As Boolean Dim colInput As String Dim arrCols As Variant Dim validCols As Collection Dim foundSheet As Worksheet, notFoundSheet As Worksheet Dim i As Long, j As Long, k As Long Dim cell As Range Dim cellValue As String Dim lastCol As Long Dim foundCount As Long, notFoundCount As Long Dim isFound As Boolean ...
Comments
Post a Comment