VBA CHEAT SHEETS - Automate Excel

← Back to document page

DescriptionVBA CodeActivate CellRange( B3 ).ActivateCells(3,2).ActivateSelect RangeRange( a1:a3 ).SelectRange(Range( a1 ), Range( a3 )).SelectRange(Cells(1, 1), Cells(3, 1)).SelectResizeRange( B3 ).Resize(2, 2).SelectOffsetRange( B3 ).Offset(2, 2).SelectCopyRange( A1:B3 ).Copy Range( D1 )CutRange( A1:B3 ).Cut Range( D1 )DeleteRange( A1:B3 ).DeleteRange( A1:B3 ).Delete shift:=xlShiftToLeftClearRange( A1:A3 ).ClearRange( A1:A3 ).ClearContentsRange( A1:A3 ).ClearFormatCountRange( A1:A3 ).CountSet to VariableDim rng as RangeSet rng = Range( A1 )Merge/UnMergeRange( A1:A3 ).MergeRange( A1:A3 ).UnMergeLoop Through CellsDim cell As RangeFor Each cell In Range( A1:C3 )MsgBox cellCELLS & RANGESVBA CHEAT SHEETSDescriptionVBA CodeActivate by Tab NameSheets( Input ).

VBA Access Sheets(“Sheet1”).Protect UserInterfaceOnly:=True Description VBA Code Activate Workbooks(“Book1”).Activate Activate First Opened Workbooks(1).Activate Activate Last Opened Workbooks(Workbooks.Count).Activate Get activate Workbook MsgBox ActiveWorkbook.Name Get ThisWorkbook (containing VBA Code) MsgBox ThisWorkbook.Name Add ...

  Excel