FindBackupRange Method (Worksheet)

In This Topic

Finds the suitable range to backup that the original worksheet can be restored correctly later (used by Clipboard Cut for example)

Syntax

Visual Basic
C#

'Declaration
 
Public Sub FindBackupRange( _
   ByRef backupRow As Integer, _
   ByRef backupColumn As Integer, _
   ByRef backupRowCount As Integer, _
   ByRef backupColumnCount As Integer, _
   Optional ByVal clear As Boolean, _
   Optional ByVal valueOnly As Boolean, _
   Optional ByVal includingShape As Boolean _
)

'Usage
 
Dim instance As Worksheet
Dim backupRow As Integer
Dim backupColumn As Integer
Dim backupRowCount As Integer
Dim backupColumnCount As Integer
Dim clear As Boolean
Dim valueOnly As Boolean
Dim includingShape As Boolean
 
instance.FindBackupRange(backupRow, backupColumn, backupRowCount, backupColumnCount, clear, valueOnly, includingShape)

public void FindBackupRange( 
   ref int backupRow,
   ref int backupColumn,
   ref int backupRowCount,
   ref int backupColumnCount,
   bool clear,
   bool valueOnly,
   bool includingShape
)

Parameters

backupRow
backupColumn
backupRowCount
backupColumnCount
clear
valueOnly
includingShape

Reference

Worksheet Class
Worksheet Members