Sunday, April 20, 2008

Do Herpes Outbreaks Become Worse With Age?

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