Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is the final product. Thank you so much for your help.
Erik Private Sub Worksheet_Change(ByVal Target As Range) Dim colNames As Collection Dim c As Range Dim rng As Range Dim iCt As Integer Dim iRow As Integer On Error Resume Next For iRow = 3 To 37 Step 2 Set colNames = New Collection Set rng = Sheets("Tracker").Range("G" & iRow & ":CI" & iRow) For Each c In rng Debug.Print c.Address colNames.Add c.Value, c.Value Next c Sheets("Student Info").Cells(((iRow - 1) / 2) + 3, 9) = colNames.Count Set colNames = Nothing Next iRow End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting names | Excel Worksheet Functions | |||
counting names | Excel Discussion (Misc queries) | |||
counting of names | Excel Discussion (Misc queries) | |||
counting names | Excel Worksheet Functions | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |