Refer to rows and columns in Excel using macro

• Click on tools in the menu bar, select Macro and from the options select Visual Basic Editor
• In the VBA editor window click on the insert menu and select module
• Now enter the following code: Sub MakeRowBold()
  Worksheets("Sheet1").Rows(1).Font.Bold = True
  End Sub
• You can also use the shortened code: Sub MakeRowBold()
  Sheet1.Rows(1).Font.Bold = True
  End Sub
• Click on run '>' button or press F5 from the keyboard to execute the macro
• The data in row 1 gets highlighted (bold).
• If you wish to work with several different rows at the same time you can use the code: Sub SeveralRows()
  Worksheets("Sheet1").Activate
  Dim myUnion As Range
  Set myUnion = Union(Rows(1), Rows(3), Rows(5))
  myUnion.Font.Bold = True
  End Sub
• After defining the name the code activates the sheet 1
• Then we define a variable object using Dim (short for dimension) with the name myUnion and data type as range
• Then we include or set the rows defined by myUnion
• When you type myUnion and a '.' after it you automatically get the options like Font when you type 'fo' after the dot. Select Font from the options. Then you type a '.' after Font to get more options like 'Bold'. Select bold.
  
• Set the myunion.font.bold as true and all data in the rows becomes bold once you run the macro by pressing the '>' run button or the F5 key from the keyboard. Try it out!

Background info: You can use the Excel Rows property or the Excel Columns property to work with rows or columns in Excel. These properties return a Range object that represents a range of Excel cells. In the following example, Rows(1) returns row one on Excel Sheet1. The Bold property of the Font object for the Excel range is then set to True.
Sub MakeRowBold()
Worksheets("Sheet1").Rows(1).Font.Bold = True
End Sub

The following table illustrates some row and column references using the Rows and Columns properties in Microsoft Excel.