Hi everybody,

Private Sub CommandButton1_Click()

For Counter = 9 To 47
Set CurCell = Worksheets("Vote Counter").Cells(Counter, T11)
If CurCell.Value <> "--" Then CurCell.Value = "Yes"
Next Counter
End Sub


I am trying to make this For loop work, by using the value of cell T11 in the column number of the cell but getting this error message:
"Application-defined or object-defined error"

Obviously having the plain name of the cell T11 doesn't work, I just couldn't found any answer to this by Google-ing for similar scenarios.

Of course, this For loop works by having a real number there.

Would someone help me?