Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using this macro graciously provided by a group member. I am trying to
modify it so that it is case sensitive to the values in ColA. Thank You in advance for your help. Dim iRow As Long Dim FirstRow As Long Dim LastRow As Long Dim wks As Worksheet Set wks = Worksheets("Sheet1") With wks FirstRow = 2 'headers in row 1 LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row .Range("A1:C" & LastRow).Sort _ key1:=.Range("A1"), order1:=xlAscending, _ key2:=.Range("c1"), order2:=xlAscending, _ key3:=.Range("b1"), order3:=xlAscending, _ header:=xlYes For iRow = LastRow To FirstRow + 1 Step -1 If .Cells(iRow, "A").Value = .Cells(iRow - 1, "A").Value _ And .Cells(iRow, "C").Value = .Cells(iRow - 1, "C").Value Then .Cells(iRow - 1, "B").Value _ = .Cells(iRow - 1, "B").Value _ & ";" & .Cells(iRow, "B").Value .Rows(iRow).Delete End If Next iRow End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation ... Case Sensitive? | Excel Discussion (Misc queries) | |||
Case sensitive filtering | Excel Discussion (Misc queries) | |||
Getting a case sensitive match? | Excel Worksheet Functions | |||
Case Sensitive w/ IF | Excel Worksheet Functions | |||
Case sensitive vlookup | Excel Discussion (Misc queries) |