Not sure if this you what you want. It loops through each cell in column H to the last one with something in it.
Sub x()
Dim varCounter As Integer
Dim rng As Range
With Sheet1
For Each rng In .Range("H2:H" & Cells(Rows.Count, "H").End(xlUp).Row)
Select Case rng
Case 65536
rng.Offset(, 1) = "Read"
Case 131072
rng.Offset(, 1) = "Write"
Case 196608
rng.Offset(, 1) = "Modify"
Case 262144
rng.Offset(, 1) = "Execute"
Case 524288
rng.Offset(, 1) = "Delete"
Case 1048576
rng.Offset(, 1) = "Change Permissions"
Case 2097152
rng.Offset(, 1) = "Take Ownership"
Case 1
rng.Offset(, 1) = "Read Contents"
Case 2
rng.Offset(, 1) = "Write Contents"
Case 8
rng.Offset(, 1) = "Delete"
Case 1677216
rng.Offset(, 1) = "Search"
Case 1769472
rng.Offset(, 1) = "Full"
Case Else
rng = "No Writes Assigned"
End Select
Next rng
End With
End Sub
Bookmarks