Working with Cells

Enter a value

Range(“A1”).Value = “Sales Report”

Read a value

Sales = Range(“B2”).Value

Format a cell

Range(“A1”).Font.Bold = True

Working with Rows

Rows(“1:1”).Font.Bold = True

Working with Worksheets

Worksheets(“Sales”).Range(“A1”).Value = “Monthly Sales”

Add a Worksheet

Worksheets.Add

Rename a Worksheet

ActiveSheet.Name = “Report”

Practice

Create a macro that:

  • Creates a new worksheet
  • Adds a report title
  • Copies selected data
  • Formats the heading
PreviousNext