Method: MoveArea for Sheet
- Updated2024-09-12
- 2 minute(s) read
DIAdem VIEW > Methods > Method: MoveArea for Sheet
Method: MoveArea for Sheet
Moves an area in DIAdem VIEW and splits the specified target area in the same or in another worksheet. Use the Move for Areas method to copy an area within the same worksheet. Use the CopyArea for Sheet or the Copy for Areas method to move an area.
Set oArea = Object.MoveArea(SourceAreaNameOrIndex, TargetSheetNameOrIndex, TargetAreaNameOrIndex, enumSplitDirection, Ratio)
| Object | Sheet Object with this method | ||||||||||||
| SourceAreaNameOrIndex | Variant Specifies the name or the index of the area DIAdem moves. | ||||||||||||
| TargetSheetNameOrIndex | Variant Specifies the name or index of the worksheet to which DIAdem copies the area. If you specify an empty string, DIAdem creates a new worksheet and ignores the subsequent parameters. | ||||||||||||
| TargetAreaNameOrIndex | Variant Specifies the name or index of the target area. | ||||||||||||
| enumSplitDirection | LongInteger Specifies the relative position of the moved area to the target area.
| ||||||||||||
| Ratio | Double Specifies the split ratio for values from 0 to 1. The split ratio is the part of the original area which the moved area occupies. If the split ratio is 0.25, the moved area takes up a quarter of the original area. | ||||||||||||
| oArea | Area Returned object of the moved area. |
The following example moves the first range of the active worksheet to the right of the first area of a new worksheet. The moved area occupies one quarter of the target area.
| VBScript | Python |
Dim oMySheet, oNewSheet, oMyMovedArea Set oMySheet = View.ActiveSheet Set oNewSheet = View.Sheets.Add("MyNewSheet") Set oMyMovedArea = oMySheet.MoveArea(1, oMySheet.Index, 1, eSplitRight ,0.25)
The following example moves the first area of the active worksheet to a new worksheet.
| VBScript | Python |
Dim oMySheet, oMyMovedArea Set oMySheet = View.ActiveSheet Set oMyMovedArea = oMySheet.MoveArea(1, "", 1, eSplitRight ,0)
See Also
Objects Overview | CopyArea for Sheet | Copy for Areas | Move for Areas
Examples
Alignment Functions in DIAdem VIEW | Automatic Display of Harmonic Frequencies | Bird's Eye View Display | Calculating a Tangent to a Curve | Contour Display in DIAdem VIEW | Creating and Viewing Long Data Channels | Dynamic Display of Statistical Characteristic Values in DIAdem VIEW | Overlaying Objects in Videos | Planetary Motion | Synchronizing Videos and Data | Synchronizing Videos and Waveform Data | User Dialog Box in VIEW for the Calculation of the FFT and Harmonic Frequencies | Using a User Command to Calculate the Difference between the Y-Values | Various Display Modes in DIAdem VIEW | Vibration Data Analysis with Parallel Processing | Viewing and Automatically Analyzing Data