Macros/Basic/Calc/Ranges

Return to Index

Get address like struct

 * Only for cells


 * For ranges

Group of ranges

 * Create and add ranges


 * We can use an array


 * Remove

Columns

 * Count


 * Get by index


 * Get by name

Rows

 * Count


 * Get by index

Current selection
CAUTION: Current selection can be many things.

Ranges with name

 * Manage names Ctrl+F3


 * Count


 * Get by index


 * Get by name


 * Add new

For flags look: NamedRangeFlag


 * Remove


 * Export list

Cursors

 * Create by range


 * Move to next cell


 * Move to previous cell


 * Move to (Columns, Rows)


 * Move to start


 * Move to end


 * Expand to current region

Tip: Get last used row in range


 * Expand to current array


 * Expand to merged area


 * Expand to entire columns


 * Expand to entire rows


 * Change size of range


 * Move to start of used area


 * Move to end of used area

Argument expand (True) or not (False) the range selection.

Special selections
Tip: All next methods, always get a group range (ScCellRangesObj)


 * Get visible cells


 * Get empty cells


 * Get cells with text

Look flag options: CellFlags

Tip: You can sum two or more values.


 * Get cells with error in formula

Look flag options: FormulaResult


 * Get values differents by column.


 * Get values differents by rows.


 * Get intersection cells

Copy
You can copy columns or rows, but make sure that the cell target it's the first cell.

Insert

 * Insert and cells down

For other options look: CellInsertMode


 * Insert columns


 * Insert rows

Delete

 * Delete and move cells up

For other options look: CellDeleteMode


 * Delete columns


 * Delete rows