Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Use the Range and Cells properties of the Worksheet object to return a Range object

Sub rangeColor()     Range("A:B").Font.Color = vbRed End Sub