Loop That Will Count Number Of Comments In a Column Between Empty Cells

Hey there,

The upload link isn't working for me so the below is the best I can do. Does that help?

Sorry!

A B C D E F G H I J K L M N O P Q R S T U
WH PN DESC BIN DI OH OO OFC ROP LT SS PIS OI NET LIST SLC COM C12 L12 COMMENTS
1D 123456 D6H-R 41 TLA 0 0 5 0 0 0 1 2635.83 4393.04 00 2 0
1D 123456 Comment: OEM #6I9671
1D 456789 D6H-R 45 TLA YARD 0 0 7 1 0 0 1 2892.99 4821.65 00 4 2
1D 456789 Comment: OEM #8E9037
1D 456789 Comment: AVAILABLE ON ITR P/NCR55

That didn't work at all. Below is the code that I am using. I can find the items with data in the columns and can count place the 1 beside them. But if there are multiples in a row I would like them to count up (1,2,3) until there is a blank in Column U then the count would start over at the next cell that has data. Does the below help with figuring this problem out?

Sub Macro1()
'
' Macro1 Macro
Dim endRow As Long
Dim rangeOne As Range, rangeTwo As Range

'
endRow = Sheets("Report").Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To endRow
If Range("U" & i).Value <> "" Then
Range("T" & i).Value = 1
End If
Next i
'
End Sub