I read through a few online tutorials, and use the macro
record to learn how to set formats. But I am wondering is there a way to do the
following, without using .Select? Or what is the preferred way by
programmers?
Requirement for the simple
macro:
- Loop through all the
worksheets (visible only) - Set bold format to the top row,
and set the background to grey - Reset the selection to A1
position
()
Sub
SetAllTopRowBold()
Dim ws As Worksheet
On Error Resume
Next
For Each ws In ThisWorkbook.Worksheets
If ws.Visible
Then
ws.Activate
Rows(1).Select
Selection.Font.Bold =
True
Selection.Interior.Color = RGB(190, 190, 190)
Range("A1").Select
End If
Next ws
End
Sub
No comments:
Post a Comment