Excel VBA Basic Training

Excel VBA Basic Training

Referencing

Referencing

Workbook
Workbooks(“NameOfWorkbook.fileExtenstion”)
Workbooks(“Workbook1.xlsx”)
ActiveWorkbook

Worksheet
Worksheets(“SheetName”)
Sheets(“SheetName”)

Range
Columns(1)
Columns(“A:A”)
Rows(“1:1”)
Range(“A1:A10”)
Range(“A1:A10,C1:C10”)

Cell
Range(“A1”)
Activecell
Cells(1,1)

Full Example
ActiveWorkbook.Sheets(“Sheet1”).Range(“A1:A10”).Select

[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]

Add comment