The SetCameraFrame method works similarly to Excel when Insert/Picture or Insert/Screenshot is used and the formula of the picture frame is set to a range on a worksheet.
The range specified in the formula will be rendered as an image within the picture frame.
The image is automatically updated with the contents of the rendered range whenever that range changes.
The camera-frame is created if it doesn't exist.
To have the camera image appear exactly like the camera range, do not specify Height, Width, EndColumn, or EndRow.
| Overload Name | Description |
|---|---|
| General | Add or modify a camera-frame. The SetShape method can be used to manipulate a camera-frame once it is created. |
Add or modify a camera-frame. The SetShape method can be used to manipulate a camera-frame once it is created.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Name | The name assigned to the camera-frame. This can be used to identify the camera-frame after it is created. |
| CameraRange | The range to be displayed inside the camera-frame. |
| Width |
The width of the camera-frame in points. The EndColumn argument can be used instead of this. The Width argument will override the EndColumn argument. If neither Width nor EndColumn are specified then the width of the camera-frame will be the width of the camera-range. |
| Height |
The height of the camera-frame in points. The EndRow argument can be used instead of this. The Height argument will override the EndRow argument. If neither Height nor EndRow are specified then the height of the camera-frame will be the height of the camera-range. |
| Column | The column to put the Camera into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| ColumnPoints | The position of the left edge of the Camera in points. If used with the Column argument then the two are added together. |
| EndColumn |
The specified column the will define the width of the camera-frame. The Width argument can be used instead of this. The Width argument will override the EndColumn argument. If neither Width nor EndColumn are specified then the width of the camera-frame will be the width of the camera-range. |
| Row | The row to put the Camera into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| RowPoints | The position of the top edge of the Camera in points. If used with the Row argument then the two are added together. |
| EndRow |
The row the will define the height of the camera-frame. The Height argument can be used instead of this. The Height argument will override the EndRow argument. If neither Height nor EndRow are specified then the height of the camera-frame will be the height of the camera-range. |
| Placement |
The placement behavior of the camera-frame. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|