Sub change_font_multiple_column()
'We can select multiple columns using below syntax
'For single column
Worksheets(1).Range("A:A").Font.Bold = True
'For multiple sequential columns
Worksheets(1).Range("A:F").Font.Bold = True
'For multiple non-sequential columns
Worksheets(1).Range("A:A,F:F").Font.Bold = True
'Please note that you can not only change the font of the columns but also change the other
'properties like alignment, font style, indentation etc
'Alternative way to select columns is given below
Worksheets(1).Columns(2).Select '- select entire Column at 2nd position
Worksheets(1).Columns("B").Select '- select entire Column B
End Sub
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.
No comments:
Post a Comment