Di l d i h ll read only r displayed in the cell count

This preview shows page 7 - 8 out of 8 pages.

dild ihllread-only (R)displayed in the cellCountno. of cells in a rangeread-only (R)ColumnRowindex number of column or rowof single-cell rangeread-only (R)13Addressabsolute address of cell or rangeread-only (R)Others: HasFormula, Font, Interior, Formula, NumberFormatRange object methodsSelectselect a cell or range of cellsCopyPasteClearerase contents of the cellRange(“C1:D4”).SelectSelection.CopyRange(“A1”).SelectActiveSheet.PasteRange(“C1”).Copy Range(“D1)14Deletedelete the cell or range, shifting other cellsinto place
8Using built-in functions in VBA codeVBA’s built-in functionsExcel’s built-in functionsThere are two families of intrinsic (built-in) functions inExcel/VBAOne is in VBA world and the other inExcel/VBA. One is in VBA-world and the other inspreadsheet-world. It is possible to use both familiesin your VBA code.Common built-in VBA functions (details of use in Help)AbsSinIntValMsgBox15SqrExpLogCosTanAtnLenRndLeftRightMidStrTimerUCaseLCaseInputBoxTimeDateInStrArrayHow to invoke Excel spreadsheet functions from VBA:Application.WorksheetFunction.function-name (arguments)Example: creating a function RangeArrayuses Min and Max functions inExcel, not available in VBA16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture