April 2006
Beginner
1114 pages
98h 16m
English
worksheet.Range([Cell1], [Cell2])
Returns a Range object that represents a range of cells.
The following code highlights batting averages .300 and over:
For Each c in Worksheets("WombatBattingAverages").Range("B1:B10")
If c.Value >= 0.3 Then
.Font.Color = RGB(255, 0, 0)
End If
Next cRead now
Unlock full access