VBA Class Worksheet Objects

Worksheet Objects

The Worksheet object is a member of the Worksheets collection and contains all the Worksheet objects in a workbook.

Example

Worksheets(1).visible=false or true

Workshets(“sheetname”).visible=true or false

Range Objects

Range Objects represent a cell, a row, a column, or a selection of cells containing one or more continuous blocks of cells.

Example

Worksheets(1).range(“a3”).value=”date”

Worksheets(“sheetname”).value=”time”

TO DELETE RANGE

    Range("A:K").Delete

    Range("1:20").Delete

FONT

    Range("B2") = "Georgetown Dry Cleaning Services"

    Range("B2").Font.Name = "Rockwell Condensed"

    Range("B5") = "Order Identification"

    Range("B5").Font.Name = "Cambria"

CONTINUE