I have some coding to make a combo box.
Range("AK4").Select
ActiveSheet.DropDowns.Add(2040, 110.25, 63, 15.75).Select
With Selection
.ListFillRange = "$BA$12:$BA$14"
.LinkedCell = "$BC$4"
.DropDownLines = 8
.Display3DShading = False
End With
I want to repeat this process for about 200 rows. I know you can put an "i" [I believe] in the place of the row # and say something like for i=# to i=# and so on. I just don't remember how to do it exactly.
I have made the row #s that must change RED. Thank you!
Bookmarks