I am looking for VBA code that will add the character ")" to the first blank cell in each row. The amount of columns in each row changes and the amount of rows change. I attached a sample spreadsheet. Thanks.
This should be a simple way of achieving what you're after;
Dim i As Integer
Dim j As Integer
i = 1
j = 0
j = j + 1
Loop Until IsEmpty(ActiveSheet.Cells(i, j))
ActiveSheet.Cells(i, j).Value = ")"
i = i + 1
Loop Until IsEmpty(ActiveSheet.Cells(i, 1))