Rockwell Automation 9307 FactoryTalk EnergyMetrix - Manual (Page 274)

FactoryTalk EnergyMetrix Software
274
Methods
Method Description
FirstCell() as Cell Returns part of Range to identify the ranges
cells, columns and rows etc.
FirstCellUsed()as Cell Returns part of Range to identify the ranges
cells, columns and rows etc.
FirstColumn() as Column Returns part of Range to identify the ranges
cells, columns and rows etc.
FirstColumnUsed() as Column Returns part of Range to identify the ranges
cells, columns and rows etc.
FirstRow() as Row Returns part of Range to identify the ranges
cells, columns and rows etc.
FirstRowUsed() as Row Returns part of Range to identify the ranges
cells, columns and rows etc.
LastCell() as Cell Returns part of Range to identify the ranges
cells, columns and rows etc.
LastCellUsed() as Cell Returns part of Range to identify the ranges
cells, columns and rows etc.
LastColumn() as Column Returns part of Range to identify the ranges
cells, columns and rows etc.
LastColumnUsed() as Column Returns part of Range to identify the ranges
cells, columns and rows etc.
LastRow() as Row Returns part of Range to identify the ranges
cells, columns and rows etc.
LastRowUsed() as Row Returns part of Range to identify the ranges
cells, columns and rows etc.
Merge() Merges the cells in the range into a single
cell
Unmerge() Removes the merging of cells in the range.
InsertRowsAbove(NumberOfRows As
Integer) Insert a number of rows above the rows in
the range
InsertRowsBelow(NumberOfRows As
Integer)
Insert a number of rows below the rows
in the range
InsertColumnsBefore(NumberOfColum
ns As Integer) Insert a number of columns before the
columns in the range
InsertColumnsAfter(NumberOfColumn
s As Integer) Insert a number of columns after the
columns in the range
Delete(ShiftDelete as enum
XLShiftDeletedCells) Deletes the specified range, and shift the
cells based on the selected Cell shift
method.