For Each .. Next Repetition Structure (For .. Next Loops)
For ... Next structures those used in the cases when s know how many times it is necessary to repeat certain instructions
ejecuion
Sub obtener_los_56_colores ()
'here known that Excel handles a palette of 56 colors
'then we know also that it is necessary to repeat a certain section of code
As Byte Dim
Range ("A1: A56").
Select For a = 1 To 56' repeat 56 times
Selection.Cells (a). Interior.color = ActiveWorkbook.Colors (a)
'book assign colors to the respective cell to
Next End Sub
0 comments:
Post a Comment